2.3.9.3 Update Historic Volumes for Baseline Forecast

Options
imadlou
imadlou
in Academy Discussions

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.

cap1.PNG
cap2.PNG

Tagged:

Best Answer

  • Dikshant
    Dikshant
    Answer ✓
    Options

    @imadlou,

    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

Answers

  • imadlou
    imadlou
    Options

    @Dikshant

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

  • VIVIANMO
    VIVIANMO
    Options

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

    截屏2023-12-03 17.41.58.png

  • Dikshant
    Dikshant
    Options

    @VIVIANMO,

    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.

Categories