I need to create a running difference function similar to the running sum function. I have a data set of work orders with quantities, an on hand quantity, and a sales order due quantity.
Order - Item - WO Qty - On Hand Qty - Sales Due Qty - Qty Needed
12345 - " 0001-1234" - 10 - 15 ---- 7 – 0
12346 - " 0001-1234" - 5 - 15 ---- 10 – 2
I need a way to calculate the qty needed. My data set includes multiple items so a reset would be the item