12 Replies Latest reply: Jul 11, 2018 11:34 AM by Elizabeth Viso RSS

    Calculating Percentages

    Elizabeth Viso

      Hello,

       

      I am trying to get the percentages of pending items.

       

      so I have an inventory count of 36, 0 pending so it'a 0% pending, but for some reason, I'm not always getting the right totals. This is what I have tried:

       

      =Count({1}DISTINCT BarcodeI) / (Count({1}DISTINCT BarcodeI)) - (Count(DISTINCT{<Pass= {'YES'}, Barcode>} Barcode) )/100

       

      I must be missing something in my expression.

       

      Thank you!