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

Type: Function

Function: ROUND

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

Description: Rounds a number to a certain number of decimal places according to defined precision (optional, 0 by default).

Sample usage:

  • ROUND(10.4) returns 10

  • ROUND(10.7) returns 11

  • ROUND(10.436, 2) returns 10.44

  • ROUND(13.5, -1) returns 10

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

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

Did this answer your question?