Keypup

<b>Syntax</b>: <code>ROUND(number, [precision=0])</code>

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

<code>ROUND(10.4)</code> returns <code>10</code>

<code>ROUND(10.7)</code> returns <code>11</code>

<code>ROUND(10.436, 2)</code> returns <code>10.44</code>

<code>ROUND(13.5, -1)</code> returns <code>10</code>

<code>ROUND(AVG(lines_changed))</code> returns the average value for the <code>lines_changed</code> field value, rounded to the nearest integer.

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

- <code>ROUND(10.4)</code> returns <code>10</code>
- <code>ROUND(10.7)</code> returns <code>11</code>
- <code>ROUND(10.436, 2)</code> returns <code>10.44</code>
- <code>ROUND(13.5, -1)</code> returns <code>10</code>
- <code>ROUND(AVG(lines_changed))</code> returns the average value for the <code>lines_changed</code> field value, rounded to the nearest integer.
- <code>ROUND(AVG(closed_at-created_at)/HOUR(),1)</code> returns the average elapsed time in hours between the creation and the closure of a record rounded with one decimal place.

ROUND

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you