Count where field contains Y

[danielnevitt]

Hi,

I have a field named CompanyGEnUK that contains either Y or N.  I am struggling to create an expression that:

1) counts when CompanyGEnUK = Y

2) only shows the results where CompanyGEnUK includes Y

In point 2, the data may have 10 result of which 5 contain CompanyGEnUK = Y.  I would like to show these results and exclude any where all the CompanyGEnUK = N

Thanks for your help.

Regards,
Daniel

[Anil_Babu_Samineni]

You mean like this

Count({<CompanyGEnUK = {'Y'}>} CompanyGEnUK)

[danielnevitt]

Thank you for the quick reply.

Is there a way to only show records where the count is greater than 0?

Regards,
Daniel

[Anil_Babu_Samineni]

Perhaps this

Count({<CompanyGEnUK = {'Y', "=Count({<CompanyGEnUK = {'Y'}>} CompanyGEnUK)>0"}>} CompanyGEnUK)

[danielnevitt]

Thanks that works to show the count.  However as I have multiple other expressions, it shows all of the results including where the above field equals 0.

Regards,
Daniel

[Anil_Babu_Samineni · Accepted solution]

Don't include red part in other expressions IF u don't need