MicroStrategy ONE
Floor (Floor Value)
Returns the closest integer less than or equal to a given number. Floor is often used as a rounding function. This is a single-value function.
Syntax
Where:
Argument is a metric representing a list of real numbers.
Example
These simple examples illustrate how the Floor function acts on positive and negative numbers, and how the results compare to the use of the Ceiling function.
| Argument Values | Floor | Ceiling |
|
947.67 |
947.00 |
948.00 |
|
463.33 |
463.00 |
464.00 |
|
-947.67 |
-948.00 |
-947.00 |
|
-463.33 |
-464.00 |
-463.00 |