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

Question

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