NULL/Zero functions

The NULL/Zero functions are used to determine how NULLs and zeros are displayed on a report.

For additional information on Null/Zero functions, refer to the MicroStrategy Functions Reference.

Is Not Null

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

Syntax

IsNotNull(Argument)

Argument is a fact or metric.

Is Null

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

Syntax

IsNull(Argument)

Argument is a fact or metric.

Null to Zero

If a value is NULL, convert it to zero (0); otherwise, keep the value.

Syntax

NulltoZero(Argument)

Argument is a fact or metric.

Zero to Null

Returns a zero (0) for all NULL values in a value list.

Syntax

ZerotoNull(Argument)

Argument is a fact or metric.