Calculation on Cumulative Values of Key Figure SAP Bex

[former_member190408]

Dear Experts - Need your expert advice. I need to perform calculation on the cumulative values of Key Figure. However I am unable to do so. Cumulated values are not used however original  values of KF are used.

	Cumulative KF -  Cumulative values based on KF1		KF2/KF3
KF1	KF2	KF3 ( Division Factor )	Expected Result	Output Displayed
10	10	2	5	5
25	35	5	7	5
30	65	9	7.222222222	3.333333333
15	80	6	13.33333333	2.5
50	130	10	13	5

As shown above KF2 is a key figure which is displaying cumulative values of KF1 i.e 10,10+25,.... Now I need to divide KF2 with KF3 to get the Expected Results column(as shown above). However, actually the results are coming out to be as shown in  column Output Displayed i.e it is dividing KF1 by KF3 instead of dividing KF2 by KF3.

Please suggest how to achieve this requirement in query designer or any other possible option.

[anshu_lilhori]

Hi,

The cumulated check box setting for Keyfigure at BEx level is only for display purpose so in case if you do any calculations on it,then it takes the original value only rather taking the cumulated  one.

So the same is happening in your case.

If you have BOBJ in place then at WebI level you can achieve the same with the help of Running sum function.

Hope that helps.

Regards,

AL

[former_member182470]

For KF2, can you try with "Calculate Single Value as" Cumulated Value" in Calculations tab in Query.

[umashankar_poojar]

Hi

       Another option would be using the cell level definitions. It can be achieved only if you have fixed number of rows and 'user don't drill down with any characteristics'.

Hope you are aware on how to achieve using cell level calculations.

Thanks,

Umashankar