About jingru

jingru

Could anyone help me with the questions below? 1. My Beginning Inventory is not showing correctly with the effect of ending inventory, it shows the same number, please see the attached screenshot. My formula is IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory 2. My shipping method is not showing data. I don't know which part of my mapping is wrong, I hope someone can help. My formula is 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Code] 3. I am not very confident with my Confirmed PO Delivery formula, it is not showing data too. Mine is: POST(PO Submitted, Shipping Time Weeks) Thank you so much!

jingru

Hi Jim, Did you have this question figured? Below is the formula I tried, but I have no results showing. If you know how to solve this, would you please help? Thank you! 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Code]

jingru

Hi Vignesh, I was looking for the solution for the same question too. My formula for DEM03 final forecast is IF Override? THEN Override Forecast ELSE Initial Demand Forecast The data appears to be correct in the module, but when I copy this formula to the sprint 2 exam it is wrong. Would you please give some more advice? I really appreciate it if you can help with this question.

jingru

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.

jingru

Hi Kevin, Thank you for helping, but it was required in 2.3.8.2 when built the module. With the Summary method set to None, I got data the first time before I messed up my time range. But even though I reset the calendar back to what it was, there is still no data showing.

jingru

Hi everyone, I followed sprint 2 step by step until I found out my data was not showing in DEM03, so I was searching for recommendations in the community and tried editing my model calendar. However, I think I messed up because, after a few changes, even my DEM01, DEM02, and DAT03 aren't showing data anymore. I tried re-import data and changed my model calendar back, but seems not working. I have the captures attached, I hope I can get some help figure out which part is not working. I really appreciate it!

jingru

Thank you! Congratulations everyone! 🎊 @akankshaschavan, @Moboraie, @nburles, @syrajkumar, @varun.joshi07, @wesleyrgreen93 @Yogeeswarareddya 🎉

Online Status	Offline
Date Last Visited	3 hours ago

About jingru

Learner's Lounge

Level 2- Sprint 3- INV01 Question

Re: Level 2 Sprint 3 Module INV01 : Formula for Sh...

Re: LVL 2 DEM03 Override? formula

Re: Level 2 Sprint 3 INV01 - Line Item Formulas

Re: Level 2 Sprint 2 Model Calendar question, data...

Level 2 Sprint 2 Model Calendar question, data not...

Re: October Achievements