ceil

Description

Returns the smallest integer greater than or equal to a number. For example, 1.5 becomes 2, and 8.1 becomes 9.

Syntax

Like many functions in DataPrime, ceil supports two notations, function and method. These interchangeable forms allow flexibility in how you structure expressions.

Function notation

ceil(number: number): number

Method notation

(number: number).ceil(): number

Arguments

Name	Type	Required	Description
number	number	true	A numeric expression to round up

Example

Use case: Calculate required SaaS licenses

When averaging license usage over time, results may include decimals. Since fractional licenses cannot be purchased, ceil ensures the number is rounded up to the nearest integer.

Example data

{
    "total_licenses": 100,
    "licenses_in_use": 31,
    "timestamp": "2024-10-10T21:00:00Z"
},
{
    "total_licenses": 100,
    "licenses_in_use": 35,
    "timestamp": "2024-10-11T21:00:00Z"
},
{
    "total_licenses": 100,
    "licenses_in_use": 22,
    "timestamp": "2024-10-12T21:00:00Z"
},
{
    "total_licenses": 100,
    "licenses_in_use": 54,
    "timestamp": "2024-10-13T21:00:00Z"
}

Example query

Function notation

aggregate ceil(avg(total_licenses)) as licenses_needed

Method notation

aggregate total_licenses.avg().ceil() as licenses_needed

Example output

{
    "licenses_needed": 36
}