MicroStrategy ONE
Ceiling (Ceiling Value)
Returns the closest integer greater than or equal to a given number. Ceiling 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
Use ceiling calculations in situations where results are expressed as specified units of measurement. For example, to avoid returns at the cent level, Ceiling could be used on a product price to round up the figures to the nearest dollar.
This simple example illustrates how the Ceiling function acts on positive and negative numbers, and how the results compare to the use of the Floor 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 |