Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How can i test VALUE NULL in set analisys?
Thank you
Hi,
Try this =Sum({$<Field -= "=Null()">} Amt)
Regards,
Sokkorn Cheav
You may also try the below code.
=Sum({<Field = {"=Len(Field) = 0"} >} Sales)
-Sridhar
Hi,
You could simply use
sum({<Field_Name1 -={}>} Field_Name2)
This might help you.
Good Luck
Regards,
Nitin Jain
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