You Asked, We Answered: Opening and Closing Inventory
In our series “You Asked, We Answered” we address questions that pop up often on our Community page.
Question:
What is the best way to open and/or close inventory within Anaplan?
Answer:
It’s easy! Just reference the table below and you are good to go:
| Line item | Formula |
| Initial Value | (Input Value) |
| Opening Inventory | PREVIOUS(Closing Inventory) + Initial Value |
| Input | (Input Value) |
| Output | (Input Value) |
| Closing Inventory | Opening Inventory + Input – Output |