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

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.

Accepted answers

sobaid

were you able to solve your problem?

All comments

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-inventory-but-it/m-p/124777#M31457

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!!

sobaid

Take your time and you'll understand the formula

sobaid

were you able to solve your problem?

AntoninaYakovleva

I've solved it. Thank you a lot.

sobaid

Can you tell me where was the issue, and how did you overcame it?

AntoninaYakovleva

Of course, I find mistake for importing data01 into the hub model. And find mistake in formula.

sobaid

Mistake in Formula in the Dat01 Module right?

AntoninaYakovleva

Now - yes. I do import again.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…