% Change Calculation

[Anonymous]

Hi there,

Struggling with a % change calculation which seems so simple but doesnt return anything.

The calculation is the current Year/Period - Previous Year/Period / Previous Year/Period

Have created measures for the Period/Years i want to compare and summed the total salary bill. However, the calculation doesnt seem to return anything and have tried several different ways of writing the calculation.

I have since removed the DIVIDE & CALCULATE commands and all i get as the result is 'Infinity'?

Any assistance would be greatly appreciated.

Thanks

[grantsamborn]

Hi @Anonymous 

Infinity is the same as "division by zero".  Check your value of [P10 F22].

[Anonymous]

I'm confused as none of these measures are zero?