Calculating Percentages

[hammermill21]

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!

[hammermill21]

Hey SUnny!

Yes that works but I had to add /100 to the end:

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

[sunny_talwar · Accepted solution]

Oh, then why don't you just use this?

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

[hammermill21]

Sunny, Perfect!!!