I have a Materials Table having the following fields
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.