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

Question & Answer
, ,
1

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.

2

Hi @hdezeduardo - Are you expecting this result. Here the check column is a calculated field which derive the percentage.

image
image1360×303 9.18 KB

The calculated field formula is:

({spend_Year}/{budget_year})*100

Hope this will help ypu.

Regards - Sanjeeb

1 Like