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 21.8, Files, Google Sheets, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Yandex Documents, YDB.

Previous