ZN

Syntax

ZN( expression )

Description

Returns expression if it's not NULL. Otherwise returns 0.

Argument types:

  • expressionFractional number | Integer

Return type: Same type as (expression)

Example

[sales] ZN([sales])
432.40 432.40
77.00 77.00
12000.00 12000.00
NULL 0.00
34.25 34.25
128.00 128.00
0.00 0.00
NULL 0.00

Data source support

ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.

Previous