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