GET FUTURE CLOSING BALANCE OF INVENTORIES VS DEMAND WITH NO NEGATIVE BALANCE

Randon KENMOE 0 Reputation points
2023-09-07T16:40:08.94+00:00

Good morning,

I would like to get the expected shortfalls for each future month with DAX based on need vs the available to launch my orders for more products. the shortfalls should take into consideration expected ins during the month + closing stock of the previous month if and only if the latter is "positive" (the stock of a month should not cover a shortfall from last months).

I'm desperately seeking for your support.

Randon

User's image

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,437 questions
{count} votes