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 |
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.