2.3.10 Activity: Create Demand Forecast

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

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
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…