IsNull

Returns TRUE if the value is NULL; otherwise, returns FALSE. This is a comparison function.

Depending on your MicroStrategy product and licensing, this function may not be available.

Syntax

IsNull(Argument)

Where:

Argument is a fact or metric.

Usage Notes

The IsNull and IsNotNull functions work only with the data returned from the database. For example, if the database data is NULL, the IsNotNull function returns a FALSE. However, you may see NULL data when you manipulate a report after its original generation and that manipulation does not regenerate the data from the database. This can happen when you page by, for example, and the result includes a NULL.