4 Replies Latest reply: Aug 9, 2016 8:27 AM by Stefan Desauv RSS

    Count If text begins with XXX

    Stefan Desauv

      Hi

       

      I'm trying to find a way apply the string "search" function into a count if expression.

       

      Meaning, I want my count expression to work with several "IF" criterea, one of them being that the data have to begin 'XXX*'.


      Does that makes sense?


      My current expression:

      Count(if(CUSTOMER <> 'AA' And CUSTOMER <> 'BB' And CUSTOMER <> 'CC' AND CUSTOMER = 'HELLO*' ,  INCOME))

       

       

      Thanks