Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi, try this:
Count({<DOL1={'01/01/1900', ">=$(=Today())"}>} DISTINCT EmpCode)
Hi, try this:
Count({<DOL1={'01/01/1900', ">=$(=Today())"}>} DISTINCT EmpCode)