You Asked, We Answered: Opening and Closing Inventory

Jill King

President and CEO

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