% Calculations of Cummulated Values

Hello,

I have a query that is using two key figures which are cummulated down the column (Plan and Actual). I have one formula which subtracts the Plan from Actual and again is cummulated. Finally i have a Variance formula which takes the previous formula divides by actual.

The result of that is looking the values before they are cummulated instead of after. I have read the OLAP engine does not support this.

Does anyone have any workarounds, i have seen some other posts on here but none with specific examples of how to do it.

We are using 04s, BI sp 11, and BEx sp 12.

Thanks in advance.