3 Replies Latest reply: Mar 13, 2013 2:24 PM by timvdberghe92 RSS

    Like function

      Hi,

       

      Does somebody knows what's wrong with my experssion?

       

      Count (if(el4naam like '*HOOL*'= 0 and (Groep1='M10' or Groep1='M20'),MISTotaal))

       

       

      Example

      -------------

       

      el4naam

      ***********

      VAN HOOL NV

      NMBS
      ELECTRABEL

      NETHERLAND VAN HOOL

       

      => I want to filter all values except VAN HOOL NV and NETHERLAND VAN HOOL

       

      Grtz
      Tim