ZERO
Created: September 05, 2015 | Updated: August 13, 2021
| Applies to versions: 15.1, 16.0, 16.1, 17.0, 17.1, 18.0, 18.1, 19.0, 19.1, 20.0, 20.1 and 20.2
Now reading version 19.0. For the latest, read: ZERO for version 21
Parent page: System Query Functions - Arithmetic Functions
Summary
Returns an integral number whose value is either 0 or 1, depending upon the parameter's numeric value. If that numeric value is zero, the number returned is 0; otherwise the number returned is 1.
Syntax
ZERO(X : Number / Numeric_String) : Number
Example Usage
ZERO(5.33)
Returns 1.
ZERO(-5.33)
Returns 1.
ZERO(0)
Returns 0.