How do I write expression to exclude a value?

[Anonymous]

Field name is Existing Groups.  Values are Yes or No.  How do I write an expression to pull in a count of ONLY the "YES" values?

I would like to create a bar chart that lists a column for "yes" and a column for "no".

[antoniotiman · Accepted solution]

Count({<[Existing Groups]={'YES'}>} [Existing Groups])

[MK9885]

count(if([Existing Groups]='YES',[Existing Groups], if([Existing Groups]='NO',[Existing Groups] )) )

[Anonymous]

Thanks!