Tom Azernour avatar
Written by Tom Azernour
Updated over a week ago

Type: Function

Function: ROUNDUP

Syntax: ROUNDUP(number, [precision=0])

Description: Rounds a number to a certain number of decimal places (optional, 0 by default), always rounding up to the next valid increment.

Sample usage:

  • ROUNDDOWN(10.7) returns 11

  • ROUNDDOWN(10.436, 2) return 10.44

  • ROUNDDOWN(AVG(lines_changed)) returns the average value for the lines_changed field value, rounded up to the nearest integer.

  • ROUNDDOWN(AVG(closed_at-created_at)/HOUR(),1) returns the average elapsed time in hours between the creation and the closure of a record, rounded up to the nearest float with one decimal place.

Did this answer your question?