% of Month: 42% (13 days so far / 31 days in the month, showing only the whole number)

I want to calculate three fields:

Pace Budget = Revenue Goal * % of Month

Pace Difference = MTD Revenue - Pace Budget

Pace Variance = Pace Difference / Pace Budget

I’m able to get the Pace Budget field to calculate correctly ($201, rounded to nearest whole number), but Pace Difference says $1 when it should be $9 ($210 - $201) and Pace Variance seems to be calculating off that $1 as it says variance is 1% (rounded to nearest whole number) instead of 4% ($9/$201).

In the Quicksight dashboard, I’m aggregating the numbers as “max” because in any other format the values are way off.

I am mimicking the same logic, but it’s not working

When I try adding “sum({mtd revenue}) - sum({pace budget})” then I get this error: “Your calculated field expression contains invalid syntax.” I’m not sure how to remove this error.

We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 3 days, we will archive the question.