Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
=Count({<WhoEmail -= {'*gmail*'}>} DISTINCT WhoId)
what about null() for WhoEMail?!?
Do you like to "include" it or not...?
Try thi
Count({$<Mail -={"*$(='*gmail*')*"}>}Mail)
Count({$<WhoEmail -={"*$(='*gmail*')*"}>}distinct WhoId)