Rounds input value to the nearest integer. Input can be an Integer, a Decimal, a column reference, or an expression. Optional second argument can be used to specify the number of digits to which to round.

NOTE: This function changes the actual data of the value. If you just want to change how the data is formatted for display, please use the NUMFORMAT function. See NUMFORMAT Function.

 

Numeric literal example:



Output:
Rounds the input value to the nearest integer: 3.

Expression example:

Output: Rounds to the nearest integer the sum of 2.5 and the value in the MyValue column.

Numeric literal example:

Output: Rounds pi to four decimal points: 3.1416.


ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName of column or Decimal or Integer literal to apply to the function
integer_valueNinteger

Number of digits to which to round.

  • Default is 0, which rounds to the nearest integer.
  • Negative integer values can be applied.

numeric_value

Name of the column, numeric literal, or numeric expression.

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal2.5

integer_value

Number of digits to which to round the first argument of the function.

Usage Notes: 

Required?
Data Type
Example Value
NoInteger literal3


Example - Exponential functions

Example - RANDBETWEEN and PI and ROUND functions