Level 2 Sprint 3 INV01 Beginning Inventory

Please refer my Screenshots. I am unable to deduce why except for week 1 , no other cells are getting populated when I use the formula "IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory".

Could this be backtracked to something I missed in earlier lessons? Stuck on this for sometime now.

Screenshot_2021-07-05_at_6_113327.png

Accepted answers

anand.shekhawat

@PranayG

You have just started building the module. You are on a correct track. Don't hesitate and just go ahead with your training modules, you will automatically figure out that how the ending inventory is getting calculated. Also make sure that you follow the training modules precisely.

Hint: you will find all the values in this module itself to calculate the ending inventory.

If you still struggle than we are here to help you out.

~Anand

All comments

anand.shekhawat

@PranayG

This is because your ELSE part of the formula works only for the 1st week of the time scale. For other cells to get populated your Ending Inventory should have some numbers, which is currently Zero in your snip.

I hope it helps

~Anand

PranayG

Thanks Anand, for the quick revert. I am still having issue understanding where the ending inventory is picking it's number. Is there anything from your experience that a novice modeller could have missed? OR is there any other information I can share here, which can find the root cause?

anand.shekhawat

@PranayG

Hint: you will find all the values in this module itself to calculate the ending inventory.

If you still struggle than we are here to help you out.

~Anand

Quick Links

Can you help?

Unanswered questions

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…