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.
Thanks in advance.
The underlying data may be for all the months. Can you check the set without the filter and action filter on the sheet. Also, it would be good, if you could send a sample workbook.