Level 2 - Sprint 2 : Activity 2.3.9.2 Update Historic Volumes for Baseline Forecast

akssaju
akssaju
in Modeling

Hi,

In this activity my formula is IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 . My result is 0, I don't know whether it is right or wrong. Can somebody please confirm this. Attaching the screenshot. Thank You very much.

Tagged:

Answers

  • ashish.banka
    ashish.banka

    @akssaju Look for the Forecast Year weeks. I guess it would be starting 1st week of FY20. You should be able to see values from FY20 1st week onwards and would be same as Volumes of 1st week of FY19 onwards.

     

    AB

  • akssaju
    akssaju

    There is value in volume but nothing in Offset volume for first forecast year

  • Shahenaz
    Shahenaz

    Because we are using First forecast year which is FY20, scroll to right, you should be able to see values for FY20.

Categories