Skip to main content
Rounds the number up to the closest multiple of equal or greater value Category: math Syntax: 
Ceiling([number], [factor])
Returns: Number Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
numbernumber or column✓ YesThe number to be rounded
factornumber✗ NoThe multiple to which the number will be rounded. Cannot be 0. Default is 1
Allowed Column Types for number: INT, FLOAT, DECIMAL

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 2

​
Examples

Ceiling([Cost])
Returns the ceiling for each row in the Cost column 
Ceiling(3.2)
Returns 4 Result: 4 
Ceiling([Cost], 0.5)
Returns the ceiling at a factor of 0.5 for each row in the Cost column
Last modified on March 13, 2026