Level 2 Sprint 2 - Creating Baseline Volume for FY21

Options
CommunityMember113744
CommunityMember113744 Member, ALL USERS Posts: 1 New Contributor
in Planning & Modeling

Hello,

 

I am having trouble pulling the Baseline Volume calculation for the Supply Chain model in Sprint 2 of the model builder trainer.  I have created the following calculation and get the attached error.  

 

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

 

Capture.PNG

 

If I take out the ELSE part of the statement for the 2nd forecast year I am able to get the FY20 volumes.  All the other calculations work for me as well.

 

Thank you,

Blake

Tagged:

Categories