Skip to Content
0
Former Member
Apr 02, 2008 at 01:40 PM

Formula on other formula with option Calculate result as Summation

14 Views

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