ROUND( ) function
Syntax
ROUND(number)
Parameters
| Name | Type | Description |
|---|---|---|
| number | numeric |
The value to round to the nearest integer. |
Output
Numeric.
Examples
Basic examples
Returns 7:
ROUND(7.2)
Returns 8:
ROUND(7.5)
Returns -8:
ROUND(-7.5)
Advanced examples
Rounding monetary values
Creates a field that is equal to the balance rounded to the nearest dollar value:
DEFINE FIELD Nearest_dollar_value COMPUTED ROUND(Balance)
Remarks
How it works
ROUND( ) returns a number equal to the number value rounded to the nearest integer:
| Positive values | Negative values | |
|---|---|---|
| Rounds up to the next integer | >= 0.5 | < 0.5 |
| Rounds down to the next integer | < 0.5 | >= 0.5 |
Rounding to a particular number of decimal places
If you want to round a number to a particular number of decimal places, use the DEC( ) function. The ROUND( ) function is the same as the DEC( ) function with zero decimal places specified.
ROUND(number)
is equivalent to:
DEC(number, 0)
ACL Scripting Guide 14.1