Result Row Calculation using other values in Result row
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.
Edited by: Victor Elms on Sep 9, 2008 6:07 PM