This content has been marked as final. Show 4 replies
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))