Round function

This function rounds the value being calculated at takeoff to a specified number of digits (from -3 to 3). Enter a separator (shown as a comma below) after the value.

  • If digit is positive, the value at that position is rounded to the nearest number.
  • If digit is negative, rounding occurs to the left of the decimal point.

Syntax

ROUND (value, digit)

Examples

ROUND (1538.3518, 3) = 1538.3520
ROUND (1538.3518, 2) = 1538.3500
ROUND (1538.3518, 1) = 1538.4000
ROUND (1538.3518, 0) = 1538.0000
ROUND (1538.3518, -1) = 1540.0000
ROUND (1538.3518, -2) = 1500.0000
ROUND (1538.3518, -3) = 2000.0000

Tip: Unlike rounding the order quantity of items on reports (Round field in the Database Item window), a formula with a ROUND function affects the actual number calculated during takeoff.