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!
Oh, then why don't you just use this?
=(Count({1}DISTINCT BarcodeI) - Count(DISTINCT{<Pass= {'YES'}, Barcode>} Barcode))/Count({1}DISTINCT BarcodeI)
What are you getting right now?
Hey Sunny,
So right now for items that are inventory count 356 and 0 are pending I get -256%, but if it's inventory count 194 and pending 188 I get the correct answer of % Pending 94%.
Seems like problem with parenthesis...
=Count({1}DISTINCT BarcodeI)/(Count({1}DISTINCT BarcodeI) - Count(DISTINCT{<Pass= {'YES'}, Barcode>} Barcode))/100
Right that makes sense, but still, the totals aren't all correct:
Sorry, but which totals are we talking about? I am a little confused
I'm sorry!
So for the line item Exit light which is:
Inventory = 356 and Pending = 0 the % Pending is - which is correct
But for the line item Fire Extinguisher:
Inventory= 173 and Pending = 1, the % Pending is 173% which is incorrect
Can you share the expressions for Pending and Inventory?
Inventory:
=Count({1}DISTINCT BarcodeI)
Pending:
=Count({1}DISTINCT BarcodeI) - Count(DISTINCT{<Pass= {'YES'}, Barcode>} Barcode)
So what you really want is this
=(Count({1}DISTINCT BarcodeI) - Count(DISTINCT{<Pass= {'YES'}, Barcode>} Barcode))/Count({1}DISTINCT BarcodeI) * 100