MicroStrategy ONE
Round (Round to Nearest Integer)
Returns the input values rounded to the nearest integer. This is a single-value function.
Syntax
Where:
Argument is a metric representing a list of real numbers.
Example
These simple examples illustrate the result of using the Round function, and compare them to the Int function results for the same values.
| Argument Values | Round | Int |
|
947.67 |
948.00 |
947.00 |
|
463.33 |
463.00 |
463.00 |
|
-947.67 |
-948.00 |
-948.00 |
|
-463.33 |
-463.00 |
-464.00 |