Ceil

Description

Ceil rounds a number up to the nearest integer.

Syntax

Ceil(value)

Parameters

Parameter	Required	Type	Description
value	Yes	Number, field, or expression	Numeric value.

Notes

Use this function in calculated fields, metric expressions, or query expressions where the function category is supported.

Example

Ceil(UnitPrice)

The expression returns the calculated result according to the current query context.