Forum Discussion

V1's avatar
V1
New Member
4 years ago
Solved

Closing and opening inventory calculation

Hi All,  I have been strugling with an issue and hope someone can help me with a suggestion. Problem: I would like to calcuate the future closing/opening inventory based on production and sales fo...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    4 years ago

    If you keep the Opening Inventory white cells in a separate column, this should be a simple task of running totals where you calculate:

     

    [Open Green Column Value] + [Production FC] - [Sales FC]

     

    and use variables or time intelligence to calculate the running total of that expression. 

     

    Do similar with the closing balance, just adjust the filters slightly.

     

    Do you have a DimDate table?

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
4 years ago

Sounds like a plan - let us know how you get on. Looking forward to your solution V1  ğŸ˜Š

V1's avatar
V1
New Member
4 years ago

Thanks AllisonKennedy  it works fine 🙂