Forum Discussion
Remaining Demand Calculation
Hello everyone, I'm trying to calculate the Remaining Demand (calcDemand) for multiple items by subtracting Current Inventory (QOH) from each Month's Demand. The data is stored in a table like the o...
What is the issue here ?
Hi gauravtanwar - I'm looking for a measure/calculation that can deliver the result on column E (calcDemand) which will basically consume demand until Inventory (QOH) drops to zero. Once Inventory has been completely depleted, calcDemand will be equal to Demand (Column D)
In the example shown on the original post