Functions
nz()
Takes a value and an alternative of the same type, and stands in for the value where it is absent. Five overloads, one per data type. The alternative is optional; what is substituted when you leave it out is not stated by the contract, so pass one where the answer matters.
Syntax · 1 of 5
nz(series int value, series int alt) → series int
Arguments
value required series int The value to check. Required. alt series int The alternative to use in its place. Optional, and of the same data type as the value. Return Type
series int Syntax · 2 of 5
nz(series float value, series float alt) → series float
Arguments
value required series float The value to check. Required. alt series float The alternative to use in its place. Optional, and of the same data type as the value. Return Type
series float Syntax · 3 of 5
nz(series string value, series string alt) → series string
Arguments
value required series string The value to check. Required. alt series string The alternative to use in its place. Optional, and of the same data type as the value. Return Type
series string Syntax · 4 of 5
nz(series bool value, series bool alt) → series bool
Arguments
value required series bool The value to check. Required. alt series bool The alternative to use in its place. Optional, and of the same data type as the value. Return Type
series bool Syntax · 5 of 5
nz(series color value, series color alt) → series color
Arguments
value required series color The value to check. Required. alt series color The alternative to use in its place. Optional, and of the same data type as the value. Return Type
series color