You've fallen into a simple trap with UPPER.
Basically you're checking if "Good" is the same as "GOOD" .... it's not the same because the case of the letters are different.
This is what you should do:
IF CONTAINS(UPPER([Condition]), 'GOOD') THEN 'Good'
ELSEIF CONTAINS(UPPER([Condition]), 'NEUTRAL') THEN 'Neutral'
ELSEIF CONTAINS(UPPER([Condition]), 'BAD') THEN 'Bad'
Than you're checking the right thing
Hi Shin and Chris McClellan,
Thank you both for your detailed message. I ran into the same problem after I corrected the formula (basically copy your formula). See my attached image. The count number for the Bad category is only 1. In fact, there are 6 Bad in total.That's what I meant: the end results worked out more like a tunnel down. In both your and my formula, we started with "GOOD" so that the good category contains all the Good related combinations. However, it doesn't happen to the Neutral or the bad category.
HI A C
with If then statement, once one condition meet, that filed is excluded from rest of conditions.
So to meet your expectation, respective count needs to be done independently..
Upper_SM_10.1_V2.twbx 40.7 KB