calculate cumulative and the correct % variance?

[Former Member]

Hello,

I have to show the Cumulative Value of Key Figure Quantity in a BEx Query. I have the following scenario:

At Present the Data appears in this form :

-> -

---

Actual - Plan - % var.

01.10.2007--100 - 80 > -20%

02.10.2007--50 - 60 > +20%

03.10.2007--90 - 100 > +11%

After changing the settings:

>>>calculate cumulate<<<

The KF Actual and Plan are correct so far

<b><u>The problem is the % variance</u>.</b>

<b>How can I get the right % variance on the calculate cumulate values.</b>

It should appear in following form in the Output :

-> -

---

Actual - Plan - % var.

01.10.2007--100 - 80 > <b>-20%</b>

02.10.2007--150 - 140 > <b>-6,6%</b>

03.10.2007--240 - 240 ><b> 0%</b>

So, how can I get this cumulated value and the <b>correct %</b> variance to appear in the Query Result.

Thanks for any help/suggestion.

Regards,

[Former Member]

Hi

Create a formula and in the formula properties chose calculate single value as variance

Regards

N Ganesh