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

    Calculating Percentages

    Elizabeth Viso



      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!