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.

What is the best way to open and/or close inventory within Anaplan?


It’s easy! Just reference the table below and you are good to go:


Line itemFormula
Initial Value(Input Value)
Opening InventoryPREVIOUS(Closing Inventory) + Initial Value
Input(Input Value)
Output(Input Value)
Closing InventoryOpening Inventory + Input – Output

Share this Story

Leave a Reply