Cumulated KF for division

[Former Member]

Hi Gurus,

I have to cumulate certain key figures and use them in division operation i.e. Cum KF1 / Cum KF2. But as the cumulation in the properties of the KFs is only for display, I'm not getting the correct results.

Any ideas, please ?

Thanks in advance.

Regards,

Sheeja

[Former Member]

Hi Sheeja,

You can create a CKF like SUMCT(KF1)/SUMCT(KF2)

SUMCT(Result) you will find under Datafunctions Folder in Formula definition Screen

Lemme know if it works

Sriman

[ravikanth_indurthi]

Hi Sheeja,

It is better to create 2 local formulas. With all the Cumulated values F1 and create one more F2 for the second cumulated values, go to their properties hide both of them, and Create 3rd Formula, with the division of 1st and 2nd that is F1 / F2.

Hope this solves Ur problem.

Assign points if this needful.

Rgs,

I.R.K