ZEROIFNULL

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns zero when input is NULL; otherwise, returns input unchanged.

1zeroifnull(<value>)

• <value>: Numeric value to check.

Returns input when it isn’t NULL. For NULL input, returns zero using the input’s numeric type.

• Requires exactly one numeric argument.
• ZEROIFNULL(NULL) returns 0.

Return zero when the input is NULL.

1SELECT zeroifnull(NULL) AS result;

Returns 0.

Return the input when it isn’t NULL.

1SELECT zeroifnull(42) AS result;

Returns 42.

• NULLIFZERO
• NVL
• COALESCE