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 notation. These interchangeable forms allow flexibility in how you structure expressions.
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
Example output
Theme
Light