I have created a set on a calculated field "Lead Time Indicator". I have given the condition 'Lead Time Indicator = Green' in the Set. While my data has both Red & Green, the Set returns the # of records incorrectly. For specific case shown in the attached screenshot, it returns all the records as 'Out of Set'. However, if I view the data, then I can see about 400 rows/ 2700 which have Lead Time Indicator as Green.
Can anyone please have a look at this & suggest where am I going wrong? Attached is the screenshot explaining the case here.