Set Analysis Expression

[sona_sa]

Hi,

Can anyone convert this expression in Set Analysis - 

Count(DISTINCT If((DOL1='01/01/1900' or DOJ >= Date(Today(),'DD/MM/YYYY')),Code))

Thanks

[sasikanth]

Try Below Expression:

Count( distinct { <DOL1={'01/01/1900'}>+<DOJ = { '>=$(=Date(Today(),'DD/MM/YYYY'))'} >} Code)

**please check date formats

[sona_sa]

Hi Sasi,

By using this expression, one part is working that is {'01/01/1900'} but after OR part is not working. Data is missing.

DOJ = { '>=$(=Date(Today(),'DD/MM/YYYY'))' 

is not working.

You can check with attached xls.

Thanks.

[sasikanth]

HI try below one

Count( distinct { <DOL1={'01/01/1900'}>+<DOJ = { ">=$(=Date(Today(),'DD/MM/YYYY'))"} >} Code)