INV01 Module Line Item Question
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
Comments
-
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
2 -
Great, thanks Misbah!0
-
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
0 -
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.
0 -
-
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
1 -
Thank You Misbah
0 -
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!!
0