1 Reply Latest reply on Jul 13, 2015 1:11 PM by Praveena Prabhu

    Sets not returning right Value

    Saurabh Singhal

      Hi Forum,

       

      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.