Not Like in Set Analysis

[Anonymous]

I want to only count records where the email is NOT LIKE  @gmail.com, but I cannot figure out the set analysis ... This is what I have come up with so far. .

=count({<WhoEmail NOT LIKE WildMatch(WhoEmail,'*gmail*')>}distinct(WhoId))

Any help is appreciated!!! Thank you

- dave

[sunny_talwar · Accepted solution]

May be this

=Count({<WhoEmail -= {'*gmail*'}>} DISTINCT WhoId)

[Anonymous]

what about null() for WhoEMail?!?

Do you like to "include" it or not...?

[neelamsaroha157]

Try thi

Count({$<Mail -={"*$(='*gmail*')*"}>}Mail)

Count({$<WhoEmail -={"*$(='*gmail*')*"}>}distinct WhoId)