Count Issue

[jpjust]

Hi,

I have an issue , please see the last field, I am doing an count of App's that is part of session type as NA and EU. But instead of giving an count of 4, it gives 2.

Here is my expression which I think is correct: If any one has any idea on how to bring the correct count, please let me know. Thanks

num(count({<SESSION_TYPE = {'EU','NA'}>}distinct [App Name]),'#,##0')

[stevejoyce]

Why do you say it should be 4?  Your expression is a count DISTINCT of App Name and i only see 2 distinct App Names.