MicroStrategy ONE
ZeroToNull
Converts a value of 0 to NULL. If the value is not 0, the original value is kept.
Syntax
Where
Argument is a fact or metric.
Example
In this simple example, the function ZeroToNull is applied to a list of values (12, 0, 97, 43, 0). The resulting list is (12, NULL, 97, 43, NULL). This function could be applied to a value list before it is acted on by another function such as Average so that zero values in a list are not included as list elements and therefore not factored into the average.