Calcilated Variance

[Robl]

I can't help but think this should be fairly simple; but I'm just having trouble with it.

I have 2 measures.
Actual
Plan

I want to find the % variance.
((actual-plan)\plan) * 100
But when I add this calculation to the cube I get the wrong answer; I'm guessing it's running the calculation on each row then summing the total.

I've taken a look a the roll up types and couldn't find anything that would shift the measure to be calculated rollup - but I might be reading it wrong.
Any hints or points in the right direction would be appreciated.

[cognostechie]

There is a Rollup tab where you can set it to 'Default (After Rollup)'. I have it this way and it is working. This is my calculation:

( "Net Sales Amt" - "Plan Net Sales Amt" ) / "Plan Net Sales Amt"

The format is set to '0%'