9 Replies Latest reply: Oct 26, 2011 8:01 AM by egnaldo souas RSS

    How to count only the items that contains a specific word

      Hi Everybody.

       

      In a past discussion i asked about how to count only the items that contains a word, the question was resolved usin the expression count(if(([Estado])='closed',[Estado])), this expression allows count in the column Estado only the cells that contains "closed".

      Now i want to make the same, but in this new case the cell contains more text not only one word, how can i do the same expression with the sentence contains????