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)
returns11
ROUNDDOWN(10.436, 2)
return10.44
ROUNDDOWN(AVG(lines_changed))
returns the average value for thelines_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.