ZERO
Syntax
<zero-expression> := 'ZERO(' <Number> ')'
Since
1.1
Return-type
Number
Description
The function ZERO converts all NULL-values from the argument into the integer-number "0". All other values are return without any manipulation. Because most function can't deal with NULL, you can use this function to pre-convert NULLs into a real number.
Examples
ZERO( Amount() )
AVG( Zero( Amount( LEAFS( Time ) ) ) )
See also
CUBE, EXISTS, ISNULL
