Hi All, I've got the formula like so for DEM03 which addresses all the answers on Question 7 (including Week14 FY21) questions. However, it does not seem to work on the final question. IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET(Baseline Forecast * (1 + Growth rate %), -52, 0) The instructions specifically call for baseline in FY21 to pick up FY20 plus applicable growth rates. Any help will be much appreciated!
... View more