Register

Level 2 Model Builder- Sprint 2 DEM03

jenniferhallce8995
New Contributor

Level 2 Model Builder- Sprint 2 DEM03

In module DEM03 there is a formula to pull forward the historic volumes data from the previous period, I have been able to do this up to the FY20 however beyond this the cells are blank. Below is my working formula which populates the forecast up to the end of FY20. 

 

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

 

I'm really stuck and not sure how to progress from here! 

Screenshot 2020-12-02 at 12.54.08.png