|
|
|
|
|
- Numeric value
- Decimal separator
Round (Function) In french: Arrondi Returns the rounded value of a numeric value according to the specified number of decimal places.
ResArrondi = Round(-16.238167, 2)
Syntax
<Result> = Round(<Numeric value> [, <Number of decimals>])
<Result>: Integer or real Rounded value of the specified numeric value. <Numeric value>: Real or currency Numeric value to round. We recommend that you use the currency type in order to get reliable results. <Number of decimals>: Optional integer Number of decimals to return. If this parameter is not specified, no decimal is returned. Remarks If <Numeric value> is included between: - 0 and 0.49: the number is rounded to 0. For example, 3.2 is rounded to 3 (no decimal).
- 0.5 and 0.99: the number is rounded to 1. For example, 3.7 is rounded to 4 (no decimal).
Caution: Rounding with the "Real" type is not precise.. In fact, operations with the "real" type are not precise due to the computer representation of the reals.. To get an exact rounding, we recommend that you use the Currency or Numeric type that uses an exact memory representation. For more details, see the real type. The decimal separator for real numbers is "." (point).
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|