I'm trying to calculate an inventory quantity but have not had success in getting the right inventory quantity to display.
The records are a portal but all the fields are within the same table 'RecordsOfUsage'
I have three fields
QtyAdd defined as a number default data value is 0
QtyDistribute defined as a number default data value is 0
QtyInventory defined as a calculation
The calculation for QtyInventory is as follows;
If (QtyAdd ≠ 0; QtyInventory + QtyAdd; If (QtyDistributed ≠ 0; QtyInventory - QtyDistributed;QtyInventory))
This is a sample of my results