isNan

Returns true if its argument is NaN.

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.

Syntax

isNan(double value)

• value : value to test

  Returns

  bool

Notes

Function isNan tests whether its argument is NaN. It returns true if the argument is NaN and false otherwise.