Built-in Functions → isNan
isNaN() is a boolean function that tests whether its argument is NaN. It returns true if the argument is NaN and false otherwise.
Signature
isNan(double value)
- value : value to test
Returns
bool
Example
Determine whether any items in AMOUNT_SOLD are NaNs.
isNan(Sales_Acme.Sales.AMOUNT_SOLD)
In this example, isNan
will test all items in the AMOUNT_SOLD column and return true or those that are NaN and false otherwise.