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])