OR CONDITION in SET ANALYSIS EXPRESSION

[sona_sa]

Hi,

I have an expression - Count(DISTINCT If((DOL1='01/01/1900' or DOL1 >= Date(Today(),'DD/MM/YYYY')),EmpCode))

Output is coming correct - 4719

When I am using  SET ANALYSIS - Output is wrong - 4701.

Count({<[DOL1]={'01/01/1900'}>+<[DOL1]={">=$(=Date(Today(), 'DD/MM/YYYY'))"}>} Distinct [EmpCode])

Can anyone correct the same. Please find the attached xls for data.

Thanks.

[TiagoCardoso · Accepted solution]

Hi, try this:

Count({<DOL1={'01/01/1900', ">=$(=Today())"}>} DISTINCT EmpCode)