nullinf(X)
Returns N/A if the given value is an infinite value.
Syntax
nullinf(X)
Input
Argument | Type | Description |
---|---|---|
X |
any numeric type | A column name |
Return Value
Returns N/A if the value in column X
is an infinite value (positive or
negative). Otherwise, returns the value in column X
.
If the value in column X
is N/A, the result is N/A.
Sample Usage
X |
nullinf(X) |
---|---|
1/0 | NA |
1/5 | 0.2 |
0/0 | NA |
NA | NA |