round(bigdecimal a, b)

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