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

Type: Function


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

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

Sample usage:

  • ROUNDDOWN(10.7) returns 10

  • ROUNDDOWN(10.436, 2) returns 10.43

  • ROUNDDOWN(AVG(lines_changed)) returns the average value for the lines_changed field value, rounded down 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 down to the nearest float with one decimal place.

Did this answer your question?