L2 3.3.5 Wrong result INV 01 for begining inventory and shiping time weeks

[AntoninaYakovleva]

Hello,

can you help me for find mistakes:

1. Begining inventory

2. And wrong result for shipping time weeks = 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product]

Here is my results:

I can't find misstakes. Everything seems correct.

Thank you.

[sobaid]

Check for the lesson of Sys01 module,may be you might have missed some formulas there in (Not first week of Timescale?)

[AntoninaYakovleva]

No, i added this items:

[sobaid]

okay, could you show the formula you used for beginning Inventory?

[AntoninaYakovleva]

IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

[sobaid]

This might help!

https://community.anaplan.com/t5/Anaplan-Platform/I-ve-entered-the-formula-for-the-beginning-invento...

[AntoninaYakovleva]

As you see in screens, i've already write all formulas. But my data isn't correct

[AntoninaYakovleva]

With Shipping Time Weeks - solved.

Beginning inventory - not clear. Please, help for solving.

[AntoninaYakovleva]

I'm slill confised in 13 on 1st week, in all tables i see this number for this period (but in the lesson it is 13000). Where i have mistake?

[sobaid]

Hey! I think you should check the lesson for DAT01 beginning Inventory cause the first value 13000 comes from there when you check the boolean is not true for that and you will be alright! You are almost there!!