Logo
  • Submit a request
  • Sign in
  • Home
  • What's New
    1. Sigma Computing
    2. Function Index
    3. Logical Functions

Zn

Returns the argument if it is not null, otherwise returns zero.
This function is helpful if you want to use zero values instead of null values.

Usage

Zn(argument)

argument (required) The number value to be checked.

Examples

(1) Returns 3.

Zn(3)


(2) Returns 0.

Zn(null)


(3) Returns 0 for every row in the column that is null.

Zn([Quantity])

Screen_Shot_2021-02-23_at_2.45.09_PM.png

Related Functions

Coalesce - Returns the first non-null value from the arguments provided.

IsNull - Returns True if the argument is null. Otherwise returns False.

IsNotNull - Returns True if the is NOT null. Otherwise returns False.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.

© Sigma Computing
Links
  • Sigma Home
  • About Us
  • Start Your Free Trial
  • Contact Us
Support
  • Documentation
  • Function Index
Contacts
  • support@sigmacomputing.com