On a QuickSight table, I have two columns: column A has the budget for the year, and Column B has the budget that’s been spent to date. I want to create a column C = B / A in order to get % of the budget that has been executed. I have been trying with no success to create a calculated field for this.
Hi @hdezeduardo - Are you expecting this result. Here the check column is a calculated field which derive the percentage.
The calculated field formula is:
Hope this will help ypu.
Regards - Sanjeeb