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

Copy
isNan(double value)

• value : value to test

Returns

bool

Example

Determine whether any items in AMOUNT_SOLD are NaNs.

Copy
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.