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.


© Incorta, Inc. All Rights Reserved.