OR CONDITION in SET ANALYSIS EXPRESSION

sona_sa — Sat, 26 Jun 2021 13:45:23 GMT

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.

Re: OR CONDITION in SET ANALYSIS EXPRESSION

TiagoCardoso — Sat, 26 Jun 2021 17:52:02 GMT

Hi, try this:

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