2.3.10 Activity: Create Demand Forecast

EJamr · 2023-02-27T01:05:35+00:00

There was an error rendering this rich post.

Hi all,

I'm stuck on this activity, I'm pulling through a 0 value for Default Forecast on Week 6 FY21 and the answer is suppose to be 73.48..

I'm not sure where I'm going wrong, I may have used the wrong formulas in DEM03. Can someone please point me in the direction

Screenshot 2023-02-27 at 00.54.10.png

Screenshot 2023-02-27 at 01.00.40.png

Accepted answers

AjayM

Hi,

You're almost there. Just two mistakes to fix.

Syntax error, IF <condition> Then <value> Else IF (missing piece) <condition> Then <value> Else <value>
Your 'default forecast' lineitem already has growth rate applied on baseline forecast. You just have to use OFFSET upon it, for 2nd year

Cheers!

All comments

AjayM

Hi @EJamr ,

Your snapshots show that you have not completed 2.3.9 activity properly. Please make sure you satisfy the instructions given as part of below image:

While 2019 should reflect historical volume, 2020 should respect seasonality and reflect same volume as previous year, and 2021 should be 2020's volume times volume growth%. Use IF THEN ELSE statement and SYS time module, to derive respective baseline forecast for FY20 and remaining forecast years.

Cheers!

EJamr

Thank you @AjayM for your speedy response. I have made a changes to the formula in Baseline Forecast I still dont think I'm on the right track. Please let me know...

Screenshot 2023-02-27 at 12.35.29.png

AjayM

FY20 is the first forecast year, but your formula will return zero for any year except 2nd forecast year. As per shared instructions, the requirement is to return [if 1st forecast year then DAT03.offset volumes else if 2nd forecast year then 'FY20's forecast * volume growth' (you get this from default forecast lineitem) else zero]

Cheers!

EJamr

Hi @AjayM I have written this formula but I'm getting an error back..

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 Default Forecast* Growth Rate % ELSE 0

Screenshot 2023-02-27 at 15.19.53.png

AjayM

Hi,

You're almost there. Just two mistakes to fix.

Syntax error, IF <condition> Then <value> Else IF (missing piece) <condition> Then <value> Else <value>
Your 'default forecast' lineitem already has growth rate applied on baseline forecast. You just have to use OFFSET upon it, for 2nd year

Cheers!

EJamr

Ok this is great thank you very much

MichaelLind

Problem solved, question removed

Quick Links

Can you help?

Unanswered questions

Set text encoding format for anaplan connect script upload
Hi, I would like to specify in an Anaplan Connect script that UTF-8 text encoding should be used for the file I am uploading. Does anyone know the command for this, or another way to make this happen? Thanks!
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…