isnan()
Returns whether input is Not-a-Number (NaN) value.
Syntax
isnan(x)
Arguments
- x: A real number.
Returns
A non-zero value (true) if x is NaN; and zero (false) otherwise.
See also
- For checking if value is null, see isnull().
- For checking if value is finite, see isfinite().
- For checking if value is infinite, see isinf().
Example
range x from -1 to 1 step 1
| extend y = (-1*x)
| extend div = 1.0*x/y
| extend isnan=isnan(div)
| x | y | div | isnan |
|---|---|---|---|
| -1 | 1 | -1 | 0 |
| 0 | 0 | NaN | 1 |
| 1 | -1 | -1 | 0 |
Feedback
Submit and view feedback for