Forum Discussion
Solved
Inventory Data - Calculated Column Quantity On Hand
Good Afternoon,
Been struggling with this one for a while. Just can't get it working properly.
Have a table of Inventory Transactions - By Facility and Item Number:
| Facility | Item No. | Date | Quantity | TransactionType |
| ABC | 10962 | 30-Dec-21 | 1 | InvAdj |
| ABC | 10962 | 30-Mar-22 | 1 | Receipt |
| ABC | 10962 | 14-Apr-22 | -1 | Fulfillment |
| ABC | 10962 | 30-Sep-22 | 3 | InvAdj |
| ABC | 10962 | 30-Sep-22 | -1 | InvAdj |
| XYZ | 10001 | 30-Dec-21 | 1 | InvAdj |
| XYZ | 10001 | 30-Sep-22 | 1 | InvAdj |
| XYZ | 10001 | 8-May-23 | -2 | InvAdj |
| XYZ | 10001 | 8-May-23 | 2 | InvAdj |
Trying to achieve a Calculated Column so I get this:
| Facility | Internal ID | Date | Quantity | TransactionType | Qty On Hand |
| ABC | 10962 | 30-Dec-21 | 1 | InvAdj | 1 |
| ABC | 10962 | 30-Mar-22 | 1 | Receipt | 2 |
| ABC | 10962 | 14-Apr-22 | -1 | Fulfillment | 1 |
| ABC | 10962 | 30-Sep-22 | 3 | InvAdj | 4 |
| ABC | 10962 | 30-Sep-22 | -1 | InvAdj | 3 |
| XYZ | 10001 | 30-Dec-21 | 1 | InvAdj | 1 |
| XYZ | 10001 | 30-Sep-22 | 1 | InvAdj | 2 |
| XYZ | 10001 | 8-May-23 | -2 | InvAdj | 0 |
| XYZ | 10001 | 8-May-23 | 2 | InvAdj | 2 |
Any help or guidance is much appreciated.
Kind Regards,
Add an index column to differentiate inventory movements on the same say.
