11 Replies Latest reply on Feb 24, 2016 10:58 AM by Mike_Mitchell

    Calculating Total Quantity Balance

    thong127

      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