isnan()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Returns whether the input is a Not-a-Number (NaN) value.
Syntax
isnan(number)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| number | scalar | ✔️ | The value to check if NaN. |
Returns
true if x is NaN and false otherwise.
Example
range x from -1 to 1 step 1
| extend y = (-1*x)
| extend div = 1.0*x/y
| extend isnan=isnan(div)
Output
| x | y | div | isnan |
|---|---|---|---|
| -1 | 1 | -1 | false |
| 0 | 0 | NaN | true |
| 1 | -1 | -1 | false |
Related content
- To check if a value is null, see isnull().
- To check if a value is finite, see isfinite().
- To check if a value is infinite, see isinf().