NOTNULL( )

Tests if a value in a specified field is a non-null value.

Syntax

NOTNULL(source)

Argument

source

The field in which to check for non-null values.

Returns

True if a value in the specified 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 field. If there is a non-null value, display the BirthDate value; otherwise display No date specified.

IF(NOTNULL([BirthDate]), [BirthDate], "No date specified")

Copyright Actuate Corporation 2012