A newer version of this documentation is available.

Conditional Functions for Numbers

March 16, 2025

+ 12

Conditional functions evaluate expressions to determine if the values and formulas meet the specified condition.

IFINF(expression1, expression2, ...)

Returns first non-MISSING, non-Inf number. Returns MISSING or NULL if a non-number input is encountered first.

Returns first non-MISSING, non-NaN number. Returns MISSING or NULL if a non-number input is encountered first.

Returns first non-MISSING, non-Inf, or non-NaN number. Returns MISSING or NULL if a non-number input is encountered first.

Returns NaN if expression1 = expression2, otherwise returns expression1. Returns MISSING or NULL if either input is MISSING or NULL.

Returns NegInf if expression1 = expression2, otherwise returns expression1. Returns MISSING or NULL if either input is MISSING or NULL.

Returns PosInf if expression1 = expression2, otherwise returns expression1. Returns MISSING or NULL if either input is MISSING or NULL.

Example 1. Return null if infinite value is encountered.

Query

sql++
Copy
select IFINF(0 / 0, 25, 23) as INF

Result

[
  {
    "INF": null
  }
]

Example 2. Return first non-infinite value encountered.

Query

select IFINF(35, 0 / 0, 25, 23) as NONINF

Result

[
  {
    "NONINF": 35
  }
]