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

akssaju
Contributor

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

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.

2 REPLIES 2
ashish.banka
Super Contributor

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

@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
Contributor

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

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