Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Oh, then why don't you just use this?
=(Count({1}DISTINCT BarcodeI) - Count(DISTINCT{<Pass= {'YES'}, Barcode>} Barcode))/Count({1}DISTINCT BarcodeI)
Sunny, Perfect!!!