Hi,
I have recently started my Level 2 and was wondering if someone could offer me some guidance.
I'm currently working through sprint 2 but I'm struggling with the formulas for the Baseline forecast FY21.
This is what I have so far.
Baseline Forecast - IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN OFFSET('DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year',52,0)*1.1
Would someone help me with where i'm going wrong? I've looked at Anapedia for help, but I'm still quite stuck.
Thanks in advance.