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)
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!
Edited by: Freek Geldof on Apr 2, 2008 4:13 PM