How can I get % executed of a budget in table?

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

1 Like