Hi,
I am calculating a variance that uses division.
But the calculation goes wrong for the total column.
PFA the output and advice the solution
set the solve order property of the total row to 0 and the solve order of the column to 1
or
set the formula for the total row instead of total(currentMeasure within detail [...]) to aggregate(currentMeasure within detail [...])