This function rounds value a to b decimal places from the decimal separator. Because the data type BigDecimal is used internally, rounding errors, as they can happen in function round(a), are avoided. A non-numerical value a is interpreted as 0. See examples below.
Parameters
Parameter | Description |
|---|---|
a | Numerical value. |
b | (optional) Number of decimal places. Default: 0 |
Examples
Parameter a | Parameter b | Result |
|---|---|---|
2.135 | 0 | 2 |
2.135 | 1 | 2.1 |
2.135 | 2 | 2.14 |
abc | 2 | 0.00 |