NullToZero

Converts a value of NULL to 0. If the value is not NULL, the original value is kept.

Syntax

NullToZero(Argument)

Where:

Argument is a fact or metric.

Example

In this simple example, the function NullToZero is applied to a list of values (12, NULL, 97, 43, NULL). The resulting list is (12, 0, 97, 43, 0). This function could be applied to a value list before it is acted on by another function such as Average so that NULL values in a list are included as list elements and factored into the average as zeros.