How to count only the items that contains a specific word
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????
@kramelot - the Right Function with the 5 means the 5 most right characters (ERROR is 5 characters). This solution would have worked if ERROR was always the last entry in the field AND always spelt the same with no trailing spaces.
Is ERROR always in upper case (i.e. Human Entered or Electronic)? Reason I am asking is it is searching a literal - meaning 'Error' would not pick up for instance.
If it is human entered you can add an Upper function - something like:
I think the ERROR in your field Estado is not in correct lenght thats why it give wrong result Right( Estado, 5 ) means from right in the field Estado it identify the ERROR but if it is only in right and the word is ERROR.