MicroStrategy ONE
Int (Integer)
Returns the integer part of a number rounded down to the nearest integer. This is a single-value function.
Syntax
Where:
Argument is a metric representing a list of real numbers.
Usage Notes
The expression [Argument - INT(Argument)] can be used to return the decimal part of a non-integer.
Results from Int and Trunc differ only when the values are less than 0.
Example
These simple examples illustrate how the Int function acts on positive and negative numbers, and how the results differ from the Trunc function when the numbers are negative.
| Argument Values | Int | Trunc |
|
947.67 |
947.00 |
947.00 |
|
463.33 |
463.00 |
463.00 |
|
-947.67 |
-948.00 |
-947.00 |
|
-463.33 |
-464.00 |
-463.00 |