Amazon QuickSight – Ceil
The CEIL function in Amazon QuickSight rounds a number up to the nearest integer.
Syntax
#Start# ceil(decimal) #End#
This function takes one argument
- number: a numerical value or a column that contains numerical values.
Example
#Start# CEIL(3.14) #End#
This will round the value of 3.14 up to 4.
The CEIL function can be useful in data analysis and reporting when you need to round numbers up to a whole number. For example, you could use this function to round up the number of products sold to the nearest whole number.