AnsweredAssumed Answered

Calculating Total Quantity Balance

Question asked by thong127 on Feb 23, 2016
Latest reply on Feb 24, 2016 by Mike_Mitchell

Hello all,


I have a Materials Table having the following fields


Material Name

Material Quantity Received

Material Quantity Balance

Material Quantity Used

Material Status Drop down List (Quarantine ; Used ; Rejected ; Near to Expiry; Expired ; Rejected)


I want to calculate the total Quantity Used excluding the materials with the status of (Used ; Rejected ; and Expired)


Any formula for the calculation.


Thank you.