Level 2 Sprint 3 INV01
I am at the point where I am comparing my INV01 data to the Anaplan lesson example and my numbers aren't matching.
I have a couple of questions about INV01.
For Beginning Inventory: My numbers are good until week 4. Then I realized that when triggered the PO Submitted boolean, it showed up in the confirmed PO line for the exact week. Which I know is wrong, so I looked at that formula. In my Confirmed PO formula, I looked to see if a PO was Submitted and if it was then I used OFFSET to look at the PO submitted and then subtracted the number of shipping weeks.
But then I realized that there is no data in my shipping time weeks. So, I looked at the data in my DAT02 and it's all there, so it must be my formula. For my formula, I took the shipping time weeks and then looked up the sku information and shipping method. I went back to Sprint 2 and Anaplan says to condense formulas as much as possible so that's why I didn't use the same formula I use to get my Shipping method data.
I'm not sure what I am doing wrong or where to look up the information. Any suggestions on where to look?
Answers
-
- Beginning Inventory: My numbers are correct until week 4. When I trigger the PO Submitted boolean, it shows up in the Confirmed PO line for the same week, which is wrong. I used the OFFSET function to adjust for shipping weeks, but there's no data in my shipping time weeks.
- Shipping Time Weeks: The data is in my DAT02 module, so the issue must be with my formula. I tried to look up the SKU information and shipping method, but it's not working.
Is this the correct question @LStinsa .
You can useIF PO Submitted THEN OFFSET(PO Submitted, Shipping Time Weeks, 0) ELSE 0
instead of only offset
Also Shipping time weeks formula it should be similar to'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS08 SKU Details'.Shipping Method]
If you still fell any issue please post formula screenshot0
