expression showing error. please help?

[#1]

hi,

I have used below expression but it is showing error? how to set this to correct?

COUNT(DISTINCT IF(NOT MATCH(Queue,'bg','hg','hy'),ClientID)

[Clever_Anjos]

You have 3 (´s and only 2 )´s please check this

[nagarjuna_kotha]

Try This:

​COUNT(DISTINCT IF(NOT MATCH(Queue,'bg','hg','hy')),ClientID)

[sunny_talwar]

May be it with set analysis:

=Count(DISTINT {<Queue -= {'bg', 'hg', 'hy'}>} ClientID)