Distinct Count of Bar Codes

[hammermill21]

Hello Everyone,

I have the expression:

Count({<Inspected={'Not Inspected'}>}Inspected)

which count all the items that have not been inspected but I need to add to it to count all the distinct bar codes that have not been inspected. I tried adding count distinct Bar Code but the expression is incorrect.

Can anyone help? Thanks!

[sunny_talwar · Accepted solution]

So, you are saying that this isn't working?

Count(DISTINCT {<Inspected={'Not Inspected'}>} [bar codes])

[hammermill21]

Hey Sunny,

You are correct, I must have written the expression wrong in some way.

Thanks!