Summation of Key Figure

[Former Member]

Hi,

I have a following requirement :-

I need to achieve this using BEx Query Designer.

Total Plant Volume(TPV) is calculated as such

KF1 + KF2 + KF3.

If this has value, then the result is this value.

ELSE

KF4 + KF5 + KF6

If this has value, then the result would be this value

Only if neither of the above 2 has results,

Then it should be KF 7

I don`t think we could just sum (KF1 +... KF6) because the ORDER of the summation is important.

[Former Member]

Try look into this link to define CKF or Formula in Query Designer. <a href="http://help.sap.com/saphelp_nw04s/helpdata/en/23/17f13a2f160f28e10000000a114084/content.htm">http://help.sap.com/saphelp_nw04s/helpdata/en/23/17f13a2f160f28e10000000a114084/content.htm</a>

1. Create Formula. In the Definition of Formula, create a formula like below...

( (KF1KF2KF3) <> 0 ) * (KF1KF2KF3) )+ ( (KF1KF2KF3) == 0 )* (((KF4KF5KF6) <> 0 ) * (KF4KF5KF6) + ( (KF4KF5KF6) == 0 ) * KF7) ).

Hope thi helps.

Nagesh Ganisetti.

• Assign points if it helps.