Level 2 Sprint 2 - Creating Baseline Volume for FY21

CommunityMember113744

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

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

Tags

Modeling

Calculation Functions

Accepted answers

Hello @CommunityMember113744 ,

Please post your questions related to Level 2 training on the following forum,

Academy Courses and Training

On your question,

Check the time range for the line items 'Baseline volume' and 'Offset Volumes for 1st Forecast Year', it has to be same. OFFSET cannot work if they are different.

Also, you could simplify the IF as below,

IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN <formula for 1st year> Forecast Year' ELSE <formula for else part>

Thanks

Arun

All comments

Hello @CommunityMember113744 ,

Please post your questions related to Level 2 training on the following forum,

Academy Courses and Training

On your question,

Check the time range for the line items 'Baseline volume' and 'Offset Volumes for 1st Forecast Year', it has to be same. OFFSET cannot work if they are different.

Also, you could simplify the IF as below,

IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN <formula for 1st year> Forecast Year' ELSE <formula for else part>

Thanks

Arun

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…