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



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.



  • @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.



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

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