I am trying to create a simple calculation that shows Actual - Budget. Actual and Budget are in the same column and have a scenario field that distinguishes the two. For Example the table looks like this:
Scenario Amount
Actual $2,000
Actual $4,000
Budget $3,000
Budget $3,000
I created a calculated field called Budget Variance that doesn't work:
{INCLUDE [Scnro Txt]: Sum(IF [Scnro Txt] = 'ACTUAL' THEN [Sumoflocal Crncy Amt] END)}
-
{INCLUDE [Scnro Txt]: Sum(IF [Scnro Txt] = 'BUDGET' THEN [Sumoflocal Crncy Amt] END)}
How can I create a measure that calculates the difference of Actual and Budget?
Hi Michael,
this alone will work no need to use include
Sum(IF [Scnro Txt] = 'Actual' THEN [Sumoflocal Crncy Amt] END)-
Sum(IF [Scnro Txt] = 'Budget' THEN [Sumoflocal Crncy Amt] END)
Changed ACTUAL to Actual as like your Data same with budget
This will do the trick
Hope this helps
plz mark this answer as correct or helpful to close the thread
BR,
NB
