int(X)
Returns the largest integer less than or equal to the given value. The result is an integer data type.
Syntax
int(X)Input
| Argument | Type | Description |
|---|---|---|
X |
any simple type | A numeric value (or a numeric value represented as text) A scalar value or the name of a column |
Return Value
Returns an integer value corresponding to the largest integer less than or equal to
X.
If X is a decimal number, the result is the integer part of
X cast to integer data type.
If X is an integer or decimal number
represented as text, it is converted to the corresponding integer or decimal
number. If the
number is a decimal number, the result is the integer portion cast to integer data type.
If X is a value that cannot be converted to a numeric value or is N/A, the
result is N/A.
Sample Usage
X |
int(X) |
|---|---|
| -5.25 | -6 |
| -5.0 | -5 |
| 13 | 13 |
| 5.0 | 5 |
| 4.5 | 4 |
| "3" | 3 |
| "7.25" | 7 |
| "-7.5" | -8 |
| NA | NA |
Example
In this example, the int(X) function returns the largest integer less than
or equal to the given value on the sales column on the
pub.demo.retail.item table.
<base table="pub.demo.retail.item"/> <colord cols="transid, account, store, date, sku, sales"/> <willbe name="intsales" value="int(sales)"/>
