Select null values in set analysis

[#1]

What is the syntax to select null values in set analysis ?

{"=null()"} is not good...

Thanks

[#2]

if (Date(DTSORTIE)=-693593, Null(), date(DTSORTIE)) as ADHERENT_DTSORTIE,

[#3]

Hi,

From my experience: best is to replace nulls with something else on loading (like date(makedate(2099,12,31)) ); if it's not possible:

{<FieldX -= {'*'} >} doesn't work for me; {$-<FieldX = {'*'} >} works but can be tricky to handle with a complex filter; working in all cases, classical Count(If( with Isnull() function. I go for the last solution...

Hope it can help.