7 Replies Latest reply: Jul 19, 2012 12:17 PM by crossmen crossmen

# Cumulated Key Figure in Formula

Currently Being Moderated

Hi Experts,

I created a cumulated key figure B for the basis key figure A (Option in calculated key figure)  fot get this result :

A
B
22
35
49
514

After  a created another calculated key figure C = B - A , but i get always zero in thr result :

A
B
C
220
350
490
5140

Can you plz explain me whey  i get zero in the calculated key figure C , and how i can resolve this problem

thank you.

Message was edited by: Matthew Billingham - ALL CAPITALS removed from subject

• ###### Re: CUMULATED KEY FIGURE IN FORMULA
Currently Being Moderated

Hi ,

http://scn.sap.com/message/7932464#7932464

Ramitha

• ###### Re: CUMULATED KEY FIGURE IN FORMULA
Currently Being Moderated

So the  cumulated Keyfigure cannot be used in calculations because the values are just displayed, these are not stored in backend.Have another solution?

Thank you

• ###### Re: CUMULATED KEY FIGURE IN FORMULA
Currently Being Moderated

check following thread for various options

http://help.sap.com/saphelp_nw70/helpdata/en/d2/02223c5f00612be10000000a11402f/content.htm

Thanks and regards

Kiran

• ###### Re: CUMULATED KEY FIGURE IN FORMULA
Currently Being Moderated

Hi

I'm not sure whether this will work, but please try.

Try to create a Formula variable and pass the values of B in the new variable and try to apply the formula. But this time your formula should be C = (new variable) - A.

Please let us know if this works.

Regards

Murthy

• ###### Re: CUMULATED KEY FIGURE IN FORMULA
Currently Being Moderated

Can you help me please how to pass the values of B in the new variable ?

Thank you

• ###### Re: CUMULATED KEY FIGURE IN FORMULA
Currently Being Moderated

Hi

This is easy.

In the query designer, write click on anyof the keyfigure and click on create new formula and drag the KF B into the area.

Now in the forumla KF C, do the calculation.

Regards

Murthy

• ###### Re: CUMULATED KEY FIGURE IN FORMULA
Currently Being Moderated

hi,

I can create new formula on the key figure but not formula variable for this key figure.

Any suggestion?

Always i have the same problem column c = 0