Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

calculate cumulative and the correct % variance?

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
Not what you were looking for? View more on this topic or Ask a question