I need help on below list.
Pur No. Stock Qty, Sold Qty, Balance Qty.
First time when user enter the sold Qty it will work
(Stock Qty - Sold Qty = Balance Qty)
so if sold Qty is equal to Stock Qty then Balance will be zero.
But for the same No. if Sold Qty is less than Stock Qty so user will again do the entry in the same row. For example first time sold Qty 300 and second time sold Qty 200.
so for this in list first entry 300 Qty it will work like
(Stock Qty (500) - Sold Qty (300) = Balance Qty(200))
and in second entry user will click on edit option to edit the row and when user will enter Qty 200 in sold Qty column it will deduct from Balance Qty not from Stock Qty like
(Sold Qty (200) - Balance Qty (200) = Balance Qty (0)).
Can anyone please help how to write the formula for this in SharePoint OOTB List.