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

    Calculating Total Quantity Balance


      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.