Table Counting Based on Answer

[hammermill21]

Hello,

I have a table that has an inventory count, then a count of a pass and failed. To calculate the Pass or fail I'm using this:

Count({<[Bascom Pass]={'YES'}>}[Bascom Pass])

Count({<[Bascom Pass]={'NO'}>}[Bascom Pass])

But my problem is that it gives me the total for all the inventory item instead of breaking it down. When it should be For example for Exit Lights, Passed 295 and Failed 3. I've tried a few ways and nothing seems to be working.

Can someone help

[MK_QSL · Accepted solution]

What is the exact expression you are using?

Is [Bascom Pass] is associated with [LS Component]

[mdmukramali]

Hi,

Can you share the expression?

[hammermill21]

Hey Manish,

That's what the problem was. I thought it was associated but when I reloaded I realized something was changed in the backend. It is working now.

Thank you!