I am trying to test out a new inventory tracking system using Coda instead of google sheets. I am having a hard time trying to keep a running total of what inventory we have left after taking out the order amounts.
In our google sheets we are able to minus how much is being taken out and keep a running total of what we have left. This is what it roughly looks like now:
Batch Size | Amount Remaining | Order Amount |
851 | 847 | 4 |
| 514 | 333 |
| 130 | 384 |
| 0 | 130 |
Any help is greatly appreciated!