Ceil()

Format

Ceil(Number)

Returns

Returns the smallest integer that is greater than or equal to the supplied number.

Inputs

Number: The number to be processed.
Behaviour: Required
Dimension: SingleValue, Collection, MultiCollection
Valid data types: Decimal, Integer

How to format data types

Examples

Expression: Ceil(23)
Result: 23

Expression: Ceil(23.45)
Result: 24

Expression: Ceil(23.85)
Result: 24

Expression: Ceil(-23.1)
Result: -23

Release History

• Ceil() 4.6.5
  • Changed Number parameter to support MultiCollection values.
• Ceil() 4.0
  • Initial version