Problem in using formula when key figure is commulative

[Former Member]

Hi all ,

I am problem in generating the report when we use the of cummulative key figure to the formula..

consider the following senerio..

Date KF1 KF2 KF1(C) Kf2(C) Formula (KF1(C) - KF2(C)

5.10.2005 1 2 1 2 -1 (wrong result)

6.10.2005 3 4 4(1+3) 6 -1

7.10.2005 5 6 9(4+5) 12 -1

System is taking the actual KF1data is subtracted with KF2 data it not taking cummulative data, Actually my requirement i want to subract the cummulative data between two key figure (ie KF1(c)-KF2(c))

My Required Output:

Date KF1 KF2 KF1(C) Kf2(C) Formula (KF1(C) - KF2(C)

5.10.2005 1 2 1 2 -1 (Correct)

6.10.2005 3 4 4(1+3) 6 -2 (4-6)

7.10.2005 5 6 9(4+5) 12 -3 (9-12)

pls let through the lights on the above issues.

with Regards,

Hari

[Former Member]

HI Reliance

GO to that particular key figure properties ans select the check box of cumulative option .Exactly it will solve ur problem

Thanks

Murali

[Former Member]

Hi Reliance

place to key figures in the colums keyfig 1 and key fig 2

then go to properties of those two key figures then select cumulative check box .

then create formula and subtract those two keyfigures u will get the required output what ur expecting .

Thanks

Murali

[Former Member]

Hi Murali..

Thanks a lot, now i got a proper output and working fine..

what i did yesterday was i have creted a two key figure as a cummulative key figure ..

and when i try to subtract two cummulative key figure system is subtracting with actual key figure and hence i got wrong result.

Today i did same thing, only diffence is i made the third formula key figure as cummulative ..

With regarsds,

Hari

[Former Member]

Hi Hari

What about my reward points?

[Former Member]

Hi Reliance

Go to the properties of that keyfigure and select cumulative check box .hope it will helpful

Thanks

Murali