Update Historic Volumes for Baseline Forecast


Hello everyone,

I encounter a problem concerning the formula of "Offset Volumes for 1st Forecast Year" . I wrote the formula that seems logical to me but it doesn't work. Can someone help me correcting it ? Thanks in advance.

N.B : The first image represents hints for the formula and the second image is the formula that i wrote.

Best Answer

  • Dikshant
    Answer ✓


    You just missed a small thing; instead of 52, make it -52.

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

    Negative means you want to fetch values from past

    Position means you want to fetch value from future


  • @Dikshant

    Thank you for your response and time. Have a great day !

  • hello, I have the error in the formular. Could someone help me


    Please read the error. Your model does not have the 1st Forecast Year line item, or it has a slightly different name. Go to SYS01 module and refer instead copying it from here.