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.
2,165 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.