Level 2 ( Update Historic Volumes for Baseline Forecast


I'm having trouble creating the formula for this requirement: requirement.png

This is what i came up with: 


IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0


My model is taking this formula without error.  This might be a silly question, but how do i check if this is correct?  Here is what my module looks like (grid view, bp view):


DAT03 Historic Volumes. grid view.png

DAT03 Historic Volumes blueprint.png

Thanks in advance.






  • Actually i think i just answered my own question (again).  If the first forecast year is FY20 and the second forecast year is FY 21 then i think I'm on the right track.  In my 'Offset Volumes for the 1st Forecast Year' line item i'm showing zero's for the FY19 values, and i'm showing the Volumes values for FY20.  So this would appear to match the "If it is the first forecast year, then offset the values from the volumes 52 weeks earlier, else 0" - Unless i'm missing something.



  • Hello,


    I have arrived at exact same formula as yourself. I hope you did not have any further issues in forthcoming tasks.