INV01 Module Line Item Question

Highlighted
Occasional Contributor

INV01 Module Line Item Question

rachelwatsky_0-1592870431163.png

 

I'm working on Level 2, Sprint 3 in Anaplan Training and don't understand how Anaplan ended up with the numbers it did.  The picture above is the provided answers (Review the INV01 Line Item Formulas and Summary Method settings); I'm unclear as to why for W2 FY20 the Forecast Demand is different from the rest of the month's numbers.  Aren't we just supposed to be using Final Forecast from DEM03, and in there every week of the  month should have the same number.

 

Thanks!

Rachel

8 REPLIES 8
Master Anaplanner/Community Boss

Re: INV01 Module Line Item Question

@rachelwatsky 

 

Yes you are partially right in saying it should have a flat line. It should come from DEM03 Demand Forecast module. Final Forecast Line item. 

 

Final Forecast Line item has certain overrides which has to be input in Override Forecast Line item before you move forward. For Example Nutzo Bar_EN on Candyate Account is overridden and the new value is 62 for Week 2 instead of 60 differing by 2. 

 

Hope that answers your question

Misbah

Highlighted
Occasional Contributor

Re: INV01 Module Line Item Question

Great, thanks Misbah!
Highlighted
Occasional Contributor

Re: INV01 Module Line Item Question

Need Help - DEM03 Demand Forecast Module

 

Unable to understand the final forecast number 62. Tried the formula shown in the training module IF NOT Override? THEN Initial Demand Forecast but gets an error message as invalid.

 

Tried the below formula for Override? and all the check boxes were updated.

Override? = IF Override Forecast = Final Forecast THEN TRUE ELSE FALSE

Highlighted
Master Anaplanner/Community Boss

Re: INV01 Module Line Item Question

@vgurubilli 

 

Can you post the snapshot of the error that you are getting? I think it has to be either name of the line item or format/syntax.

Highlighted
Occasional Contributor

Re: INV01 Module Line Item Question

Thanks Misbah for quick response. Attached screenshot for your reference.

Highlighted
Master Anaplanner/Community Boss

Re: INV01 Module Line Item Question

@vgurubilli 

 

Override? Line item should be without formula meaning it should be open for input

Override Forecast Line item should also be open for input

Final Forecast Line item - You need to write a formula here IF Override? is Not checked then Initial demand forecast else override forecast

 

Hope that answers your question

Misbah

 

Highlighted
Occasional Contributor

Re: INV01 Module Line Item Question

Thank You Misbah

Highlighted
New Contributor

Re: INV01 Module Line Item Question

@rachelwatsky @Misbah 

 

Hi there, I am having trouble in this currently as I have been working through Sprint 3 in Level 2. I am having a hard time getting the right formulas and I keep getting errors in different parts. Let me know if anyone is available to help, thank you!!