2.3.9.3 Update Historic Volumes for Baseline Forecast

divyeshkhandpur92
divyeshkhandpur92
in Academy Discussions

Hi,

I have created a formula for the new LineItem "Offset Volumes for 1st Forecast Year" The formula looks like this

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

Offset FY19 Data.jpg

However, I do not see any data for FY19 as shown below
but I can see the data for FY20.

Offset FY20 Data.jpg

Can someone let me know that are we supposed to see the data for FY19 or am I missing something?

Tagged:

Answers

  • Rajat26
    Rajat26

    Hi divyeshkhandpur92,

    What the offset function does is get you the value from before or after the current period. The formula you have written, what it does is take the values from 52 weeks before the current period meaning values will be displayed only if you have a value 52 weeks before the current period and if the time period is outside of model time range, then the third variable of the formula comes in play it with replace those empty values with substitute values. In your case zero.

    Offset Syntax:

    OFFSET (Value to offset, Offset amount, Substitute value)

Categories