Level 2 Sprint 3 INV01 - Line Item Formulas

Options
JoanneN
JoanneN Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor
in Anaplan Community

Hi, 

 

I am stuck with the following formula that I don't seem to understand what it is looking for: 

Forecast Demand line item

This line item should display the Final Forecast value from the DEM03 Demand Forecast module. 

 
I have checked against my DEM03 formula (from Level 2) and all the formulas/values are right. My current answer is to just equate Final Forecast value to Forecast Demand but the number doesn't tally. 
 
Any hints will be helpful. Thanks! 
Tagged:

Comments

  • ANS
    ANS Member, ALL USERS, Certified Model Builder Posts: 3 Occasional Contributor

    @JoanneN 

    Greetings,

     

    In "DEM03 Demand Forecast" module select "All Accounts" in the Page Selector then compare "Final Forecast" of "DEM03 Demand Forecast" module with "Forecast Demand" of "INV01 Inventory Ordering" module. It should match.

     

    Hope this helps.

     

     

  • JoanneN
    JoanneN Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor

    Hi @Misbah and @ANS ,

     

    My DEM03-Final Forecast number tallies with my INV01-Forecast Demand (1,201) but doesn't look right with the reviewed example provided in the lesson (2,048) in Week 1 FY20 and beyond. I have attached screenshots of my work in the first 2 screenshots and the example given by the lesson in the third screenshot.

     

    The lesson link- https://learning.anaplan.com/mod/page/view.php?id=12100 

     

    Look forward to your advice. Thanks!

     

  • JoanneN
    JoanneN Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor

    @einas.ibrahim 

     

    Thanks for the guidance. I have checked my steps according to your advice and it seems like my data matches for DEM03 verification in Sprint 2.  My initial demand forecast for Week 1 FY20 is 60.

     

    I am looking at  ROUND(Default Forecast, 0, UP) for initial demand. Am I missing something? Thanks!

     

    Screenshot 2020-08-23 at 10.42.44 PM.png

  • jingru
    jingru Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 New Contributor

    Hi Joanne,

     

    Did you have the question figured out? I was looking for the solution too.

    Also, my formula for DEM03 final forecast is IF Override? THEN Override Forecast ELSE Initial Demand Forecast

     

    It appears to be correct in the module but when I use this in the exam it is wrong.

     

    I really appreciate it if you can help with this question.

Categories