Verify Is null value in set analisys

[#1]

Hello,

How can i test VALUE NULL in set analisys?

Thank you

[Sokkorn]

Hi,

Try this =Sum({$<Field -= "=Null()">} Amt)

Regards,

Sokkorn Cheav

[sridhar240784]

You may also try the below code.

=Sum({<Field = {"=Len(Field) = 0"} >} Sales)

-Sridhar

[#4]

Hi,

You could simply use

sum({<Field_Name1 -={}>} Field_Name2)

This might help you.

Good Luck

Regards,

Nitin Jain

[erichshiino]

You can include a flag in your script to test the field:

Load FIELD1,

IF( ISNULL(FIELD1), 1, 0) as FlagNullField1,

FIELD2

...

...

Then, you can test this field on set analysis:

sum({<FlagNullField1 ={1}>} FIELD2)

---> This will sum FIELD2   where FIELD1 is null

Regards,

Erich