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.
{
"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"
}
Output
Theme
Light