Ceiling
Syntax
CEILING(Numeric_Expression)
Input Parameters
Numeric_Expression
A valid double expression, such as a numeric Measure reference or a
double literal.
Return Value
Returns the smallest integer greater than or equal to the double value.
Examples
Return the Sales Amount rounded up to the nearest dollar.
CEILING([Measures].[Internet Sales Amount Local])