NOTNULL( )
Tests if a value in a specified data field is a non-null value.
Syntax
NOTNULL(value)
Argument
value
The data field in which to check for non-null values.
Returns
True if a value in the specified data field is not a null value; returns false otherwise.
Example
The following example uses NOTNULL( ) in conjunction with the IF( ) function to test for non-null values in the BirthDate data field. If there is a non-null value, the BirthDate value is displayed; otherwise the string "No date specified" is displayed.
IF(NOTNULL([BirthDate]), [BirthDate], "No date specified")

Additional Links:

Copyright Actuate Corporation 2013 BIRT iHub 2