Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Result Row Calculation using other values in Result row

Hi

I am busy writing a query in Bex and have come upon a problem. I start with 3 key figures - A, B and C. I then have 2 calculated key figures Z and Y.

CKFZ = KFA * KFB. (Result Calculation is set as total)

CKFY = KFC / CKFZ

The result set will look something like this:

CalMonth KFA KFB KFC CKFZ CKFY

01.2008 10000 0.80 6000 8000 0.75

02.2008 16000 0.75 4000 12000 0.33

Result 26000 1.55 10000 20000 0.08

What I want to achieve is for CKF Y result to be 0.50 (KF C Result / CKF Z). What the result is doing is KF C Result / (KF A Result * KF B Result).

Any help or ideas will be greatly appreciated.

Vic

Edited by: Victor Elms on Sep 9, 2008 6:07 PM

Not what you were looking for? View more on this topic or Ask a question