How to change the expression to get pass values

[#1]

Hi,

I have a expression as below in Straight table

count({<Result={'Fail'}>}DISTINCT Reference) so that I will get Number of Failures.

If I want to get Number of Pass how can I change the above expression.

Could anyone help me.

Thanks.

[Nicole-Smith]

count({<Result={'Pass'}>}DISTINCT Reference)

or

count({<Result-={'Fail'}>}DISTINCT Reference)

[#3]

Thanks. I am getting the same figures which is having for Number of Failures. Is this something because of the data in source file or do I need to change anything else?

[iktrayanov]

Remove the Distinct from your expression.

[Nicole-Smith]

If you're getting the same values, I would think you have the same numbers for both Pass and Fail...

Have you calculated by hand what it should be?  Without knowing what it should be, I can't say whether it is correct or not.