Cumulated Key Figure in Formula

crossmen crossmen Jul 16, 2012 3:03 PM

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
2	2
3	5
4	9
5	14

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

A	B	C
2	2	0
3	5	0
4	9	0
5	14	0

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

Ramitha Thalla Jul 15, 2012 3:16 PM (in response to crossmen crossmen)

Currently Being Moderated

Hi ,

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

Hope this may help you.

Regrads,
Ramitha
Report Abuse

Like (0)
- Re: CUMULATED KEY FIGURE IN FORMULA
  
  crossmen crossmen Jul 15, 2012 3:41 PM (in response to Ramitha Thalla)
  
  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
  
  Report Abuse
  
  Like (0)
Re: CUMULATED KEY FIGURE IN FORMULA

Kiran Vasant Kere Jul 16, 2012 5:08 AM (in response to crossmen crossmen)

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
Report Abuse

Like (0)
Re: CUMULATED KEY FIGURE IN FORMULA

Murthy Gunuputi Jul 16, 2012 7:14 AM (in response to crossmen crossmen)

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
Report Abuse

Like (0)
- Re: CUMULATED KEY FIGURE IN FORMULA
  
  crossmen crossmen Jul 16, 2012 12:25 PM (in response to Murthy Gunuputi)
  
  Currently Being Moderated
  
  Can you help me please how to pass the values of B in the new variable ?
  
  Thank you
  
  Report Abuse
  
  Like (0)
  - Re: CUMULATED KEY FIGURE IN FORMULA
    
    Murthy Gunuputi Jul 16, 2012 12:36 PM (in response to crossmen crossmen)
    
    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
    
    Report Abuse
    
    Like (0)
    - Re: CUMULATED KEY FIGURE IN FORMULA
      
      crossmen crossmen Jul 19, 2012 12:17 PM (in response to Murthy Gunuputi)
      
      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
      
      Report Abuse
      
      Like (0)

Go to original post