Menu
Amazon QuickSight
User Guide

ceil Function

ceil rounds a decimal value to the next highest integer. For example, ceil(29.02) returns 30.

Syntax

Copy
ceil(decimal)

Arguments

decimal

A field that uses the decimal data type, a literal value like 17.62, or a call to another function that outputs a decimal.

Return Type

Integer

Example

The following example rounds a decimal field to the next highest integer.

Copy
ceil(sales_amount)

For the field values:

Copy
20.13 892.03 57.54

The following values are returned:

Copy
21 893 58