# Zn

The function **Zn** returns the argument if it is not Null, otherwise returns zero. Zn allows the convenient use of zero values in place of Null values.&#x20;

### Syntax

`Zn(argument)`

**argument** (required) The number value to be checked.

> ### 📘
>
> *The **argument** must be a Number data type.*

> ### 📘
>
> *The function can analyze one argument at a time.*

### Example

```
Zn(3)
```

* Returns 3

```
Zn(Null)
```

* Returns 0

```
Zn([Quantity])
```

<figure><img src="https://files.readme.io/4b310ba-jk.png" alt=""><figcaption></figcaption></figure>

* Returns 0 for every row in the column that is Null.
