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.

 

Lola

Outcomes