The Round()
function rounds a number.
Rounding a number can be done according to different strategies when it comes to the edge cases (like x.5). WEM uses the Banker's Rounding strategy because of its statistical superiority and standard use in financial and statistical operations. Mind, this only applies to the Mid-Point values: the middle of the spectrum, where a decision needs to be made which way to go. So if you expect 3.85 to be rounded to 3.9 (away from zero), you'll be surprised to see WEM shows 3.8 (Banker's).
Read this wiki page about rounding strategies.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a number that is rounded to an integral number or a number of fractional digits.
Returns Invalid expression
if one of the parameter values is not a valid number.
Name | Type | Required | Description |
---|---|---|---|
Function call | Result |
---|---|
Round(5.499)
5
Round(5.501)
6
Round(3.85, 1)
3.8
Round(5.489, 2)
5.49
Round(5.499, 2)
5.50
number
numeric
a number
digits
numeric
the number of fractional digits number
is rounded.