3 Replies Latest reply: May 9, 2017 2:58 PM by neelam sehrawat RSS

    Not Like in Set Analysis

    Dave Melillo

      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