Forum Discussion
Anonymous
6 years agoNot applicable
Need Help with Variance %
I have 4 Cards as follows, but the last card (measure) is not calculating correctly...
$10,624
Assmt Budget $k
$12,500
Assmt Forecast $k
($1,876)
Assmt Variance $k
Created this measure: Asst Variance $k = SUM('ILI Budget' [Assmt Budget $]) - SUM ('ILI Budget' [ILI Assessments Forecast $k])
-6%
Assmt Variance %
Created this measure: Assmt Variance % = DIVIDE([Assmt Variance $k], [ILI Team Forecast $k)
This should be returning a value of 15% ( 1,876/12,500) not 6%. What am I doing wrong?
Thank you for your help.