Formula on other formula with option Calculate result as Summation

[Former Member]

Hello,

I am creating a query to calculate forecast accuracy for my demand planning process.

I have fields:

Forecasted Qty, Actual Qty, Absolute Delta (CKF), % FACC (CKF)

Where:

Absolute delta = ABS(Actual Qty - Forecasted Qty)

% FACC = 1-(Absolute Delta/Actual Qty)

For the resultrows in Absolute Delta (CKF) i want : Calculate result as: Summation to sum up all absolute delta's of my drill down in report.

Then I hoped % FACC would calculate in the result row with the renewed (summation) value i have in Absolute Delta result row but he keeps making calculation on basic result of formula.

Is there any way how I can make this formula calculate with the summation resultvalue of CKF? Can anyone give any help to me?

Thanks in advance for your reply!

Freek Geldof

BW Consultant

Edited by: Freek Geldof on Apr 2, 2008 4:13 PM

[Former Member · Accepted solution]

Hello Freek,

Did you change the calculate result as property Absolute Delta (CKF) or a selection where pulled in. If its a selection where u have just pulled in, then you are locally changing the property which is not going to effect % FACC (CKF). Since its a simple CKF, create a test formulae for Absolute Delta and then use in another formulae % FACC. Not sure this will solve your issue. But you can give a try.

Thanks,

Peter R

[Former Member · Accepted solution]

Hi Peter,

I defined the "Calculate result as" Summation in the query itself. So not locally.

Further investigating i found there is an operator Leaf() in formula which makes difference when formula is operating in Result row or in normal cell.

I have to investigate this option.

Greetz,

Freek