Level 2 (2.3.9.2) Update Historic Volumes for Baseline Forecast

pmorgan
pmorgan
in Modeling

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

 

2.3.9.2 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.

 

-Paul

 

Tagged:

Answers

  • pmorgan
    pmorgan

    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.

     

    -Paul

  • Niraj.B
    Niraj.B

    Hello,

     

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

Categories