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