Opening and Closing Inventory

Hi, A quite usual topic easy to solve with Anaplan is the Opening / closing inventory formula. Here is my proposal. Feel free to share yours.

Line item Formula
Initial Value  
Opening Inventory PREVIOUS(Closing Inventory) + Initial Value
Closing Inventory Opening Inventory + Input - Output 
Alternative solution  
Opening Inventory with POST POST(Closing Inventory, 1) + Initial Value.

Kind regards. Michel.


Best Answer

  • Great set-up Michel.  Very simple and very clean.  This is how I would set it up as well.