topic Re: Level 2 Sprint 3 INV01 - Line Item Formulas in Academy & Training
https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/80402#M2250
<P>Hey <LI-USER uid="34785"></LI-USER> </P><P> </P><P>The way I'd "debug" an issue like this is by examining and tracing back the formula for the mismatch value until I find a value/formula that may be the reason for the discrepancy.</P><P> </P><P><U>By examining the formulas of the Line Item and trace it back, Here is how the math works for the INV01.Forecast Demand</U></P><UL><LI>INV01. Forecast Demand = <FONT color="#0000FF">DEM03.Final Forecast</FONT></LI><LI><FONT color="#0000FF">DEM03.Final Forecast</FONT> = <FONT color="#800000">Initial Demand</FONT> OR Override (I assume you don't have Override so we'll use Initial Demand)</LI><LI><FONT color="#800000">DEM03.Initial Demand</FONT> = Round(<STRONG>Base Line Demand</STRONG>)</LI></UL><P>The Value of INV01.Forecast Demand is really dependant on the value of DEM03.Base Line Demand.</P><P> </P><P>Are you sure the formula for Base Line Demand is correct?<BR />What value do you have for Nutzo Bar_EN for All Accounts in Week 1 FY20?</P>Sat, 15 Aug 2020 17:56:02 GMTeinas.ibrahim2020-08-15T17:56:02ZLevel 2 Sprint 3 INV01 - Line Item Formulas
https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/80056#M2232
<P>Hi, </P><P> </P><DIV>I am stuck with the following formula that I don't seem to understand what it is looking for: </DIV><DIV><BR /><P><STRONG>Forecast Demand line item</STRONG></P><P>This line item should display the Final Forecast value from the DEM03 Demand Forecast module. </P></DIV><DIV> </DIV><DIV>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. </DIV><DIV> </DIV><DIV>Any hints will be helpful. Thanks! </DIV>Wed, 12 Aug 2020 14:44:36 GMThttps://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/80056#M2232JoanneN2020-08-12T14:44:36ZRe: Level 2 Sprint 3 INV01 - Line Item Formulas
https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/80150#M2235
<P><LI-USER uid="34785"></LI-USER> </P><P> </P><P>Can you please share a screenshot of what doesn't look right to you. If I have to take a guess I would say you might be seeing aggregated values of SKUs for all the accounts in INV01 module because DEM03 has SKU and Account as dimensions wheres INV01 has only SKU as a dimension.</P><P> </P><P>If not please post a snip here. Will try n help</P><P>Misbah</P>Thu, 13 Aug 2020 07:30:51 GMThttps://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/80150#M2235Misbah2020-08-13T07:30:51ZRe: Level 2 Sprint 3 INV01 - Line Item Formulas
https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/80238#M2238
<P><LI-USER uid="34785"></LI-USER> </P><P>Greetings,</P><P> </P><P>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.</P><P> </P><P>Hope this helps.</P><P> </P><P> </P>Thu, 13 Aug 2020 18:11:03 GMThttps://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/80238#M2238ANS2020-08-13T18:11:03ZRe: Level 2 Sprint 3 INV01 - Line Item Formulas
https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/80399#M2249
<P>Hi <LI-USER uid="9355"></LI-USER> and <LI-USER uid="35523"></LI-USER> ,</P><P> </P><P>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.</P><P> </P><P>The lesson link- <A href="https://learning.anaplan.com/mod/page/view.php?id=12100" target="_blank">https://learning.anaplan.com/mod/page/view.php?id=12100</A> </P><P> </P><P>Look forward to your advice. Thanks!</P><P> </P>Sat, 15 Aug 2020 14:41:29 GMThttps://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/80399#M2249JoanneN2020-08-15T14:41:29ZRe: Level 2 Sprint 3 INV01 - Line Item Formulas
https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/80402#M2250
<P>Hey <LI-USER uid="34785"></LI-USER> </P><P> </P><P>The way I'd "debug" an issue like this is by examining and tracing back the formula for the mismatch value until I find a value/formula that may be the reason for the discrepancy.</P><P> </P><P><U>By examining the formulas of the Line Item and trace it back, Here is how the math works for the INV01.Forecast Demand</U></P><UL><LI>INV01. Forecast Demand = <FONT color="#0000FF">DEM03.Final Forecast</FONT></LI><LI><FONT color="#0000FF">DEM03.Final Forecast</FONT> = <FONT color="#800000">Initial Demand</FONT> OR Override (I assume you don't have Override so we'll use Initial Demand)</LI><LI><FONT color="#800000">DEM03.Initial Demand</FONT> = Round(<STRONG>Base Line Demand</STRONG>)</LI></UL><P>The Value of INV01.Forecast Demand is really dependant on the value of DEM03.Base Line Demand.</P><P> </P><P>Are you sure the formula for Base Line Demand is correct?<BR />What value do you have for Nutzo Bar_EN for All Accounts in Week 1 FY20?</P>Sat, 15 Aug 2020 17:56:02 GMThttps://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/80402#M2250einas.ibrahim2020-08-15T17:56:02ZRe: Level 2 Sprint 3 INV01 - Line Item Formulas
https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/81176#M2282
<P><LI-USER uid="22938"></LI-USER> </P><P> </P><P>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.</P><P> </P><P>I am looking at ROUND(Default Forecast, 0, UP) for initial demand. Am I missing something? Thanks!</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2020-08-23 at 10.42.44 PM.png" style="width: 400px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/37465iCDB9CEF1B03159DD/image-size/medium?v=v2&px=400" role="button" title="Screenshot 2020-08-23 at 10.42.44 PM.png" alt="Screenshot 2020-08-23 at 10.42.44 PM.png" /></span></P>Sun, 23 Aug 2020 14:49:41 GMThttps://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/81176#M2282JoanneN2020-08-23T14:49:41ZRe: Level 2 Sprint 3 INV01 - Line Item Formulas
https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/81179#M2283
<P>Hi <LI-USER uid="34785"></LI-USER> <BR /><BR /></P><P>Ok, is it likely that this formula is not working correctly? probably not, whatever value you give the formula it'll generate the roundup value. so you need to go one step further.</P><P>Default Forecast formula is dependant on <STRONG>Baseline Forecast</STRONG></P><P>I'd look at the formula of <STRONG>Baseline Forecast </STRONG>and ensure it returns the correct value for the different time periods.<BR /><BR /></P><P> </P><P>Note: Please note that the <STRONG>Forecast Demand </STRONG>in INV01 is for a particular P3 SKU in <EM>ALL</EM> accounts </P>Sun, 23 Aug 2020 15:32:19 GMThttps://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/81179#M2283einas.ibrahim2020-08-23T15:32:19ZRe: Level 2 Sprint 3 INV01 - Line Item Formulas
https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/91160#M2573
<P>Hi Joanne,</P><P> </P><P>Did you have the question figured out? I was looking for the solution too.</P><P>Also, my formula for DEM03 final forecast is <EM>IF Override? THEN Override Forecast ELSE Initial Demand Forecast</EM></P><P> </P><P>It appears to be correct in the module but when I use this in the exam it is wrong.</P><P> </P><P>I really appreciate it if you can help with this question.</P>Tue, 17 Nov 2020 22:04:02 GMThttps://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-3-INV01-Line-Item-Formulas/m-p/91160#M2573jingru2020-11-17T22:04:02Z