Level 2 Spring 2 2.3.10 Baseline Forecast

Options

I believe the problem has to do with my time range, but my 2nd year forecast isn't populating anything. This is my baseline Forecast formula:

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

The time range is fy19-fy20 to match the Dat03 time range, while the rest of the line items are model calendar.

I've seen other people say to use Default Forecast in the Else portion, but I get the error message about the time ranges so maybe I just missed something when making one of these modules

Best Answer

  • baileyw
    Answer ✓
    Options

    Never mind I figured it out! :)