You are viewing content for 5.1 | 5.0 | 4.9 | 4.8 | 4.7 | 4.6 | 4.5 | 4.4 | 4.3 | Previous Releases


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.