Former Member

# Calculated key figure using the result as an operand.

Hello everyone,

I have the following situation.

CUBE1

C1 C2 KF1

-

A XXX 50

A YYY 75

A ZZZ 100

CUBE2

C1 C3 KF2

-

A 1/2007 150

A 2/2007 100

A 3/2007 200

Output of MULTICUBE query (using constant selections for C1 on KF2 i.e KF2 is independent of C1

and C3 on KF1 i.e KF1 is independent of C3)

Free Selection C3 = 01/2007

C1 = A

C1 C2 KF1 KF2 CKF (= KF1/Summation of KF2)

A XXX 50 # (50/225)

A YYY 75 # (75/225)

A ZZZ 100 # (100/225)

Result

• * 125 225 (1)

My apologies for the formatting...

The challenge is to come up with the above CKF that has KF1 in the numerator and the result of KF2 in the denominator.

Dorothy

10|10000 characters needed characters exceeded

### Related questions

Former Member
Posted on Feb 02, 2007 at 07:48 PM

oops there is typo here...

The Free selection is

C3 = 01/2007 - 03/2007

10|10000 characters needed characters exceeded
• Hi Dorothy,

You can try using a formula (CKF3) created doing a SUMGT function on CKF2. This will bring you a whole column populated with the CKF2 value (225) in your example, then you can do CKF1/CKF3.

Hope this helps...

• Former Member
Posted on Feb 02, 2007 at 09:35 PM

Thx Bhanu. I tried to locate SUMGT in the 'data functions' category. The entire 'Result' category function are missing. Any ideas ?

10|10000 characters needed characters exceeded
• Are you creating the formula in the left hand side? You will find this function only if you are doing the formula local in the query.

Hope this helps...

• Former Member
Posted on Feb 02, 2007 at 09:45 PM

I dont follow you. I am trying to create CKF3 using the "New calculated KF" context menu option on the left hand side of the Bex designer. In the subesequent "Edit Calculated Key Figure" screen I am unable to see the SUMGT function under 'data flow' function category.

10|10000 characters needed characters exceeded
• Hi Dorothy,

When you start creating the calc on the left hand side (as you are doing) certain functions are not available. Instead of doing that, right click on the KF structure in your query and choose New Formula. Now you will be able to see the SUMGT function.

Hope this helps...

• Former Member
Posted on Feb 02, 2007 at 09:53 PM

Thank you. I see it now.

10|10000 characters needed characters exceeded
• Former Member
Posted on Feb 02, 2007 at 10:01 PM

Thank you, Bhanu. That worked.