ROUND

Description

Returns the value rounded to the nearest integer using half-even rounding.

Syntax

ROUND(number) -> Integer

Parameters

ParameterData TypeRequiredDescription
numberDecimalYesA numeric literal, field, or expression to round.

Examples

ROUND(4.5)
-- Returns 4.
ROUND(-4.5)
-- Returns -4.

Tips

  • Throws an error if the rounded result is outside the supported 32-bit integer range (−2,147,483,648 to 2,147,483,647).