I have a file that contains a row of values for production and another row for orders.
I need a third row that will subtract orders from production, creating a list of available inventory. The available inventory row should be a running total, by day, that subtracts from current and previous days inventory when necessary.
Please help with the formula I would need to put in the available column that only subtracts from previous days when necessary, but still shows negative if the orders column is greater than the running total of the production column.
Example:
Capture.JPG
Bookmarks