Originally posted 3/30/2017 7:20:17 PM UTC

The current function "Round()" implements banker's rounding. User's would also like a function that implements standard rounding.

# Standard Round Function in Asset-Analytics

- Comment • 3

- Comment • 3

Submitted

Score15

Originally posted 3/30/2017 7:20:17 PM UTC

The current function "Round()" implements banker's rounding. User's would also like a function that implements standard rounding.

It’s ok to have banker’s rounding as the default mode but having the option to specify the MidPointRounding would be useful. I have a case where the rounding used in an Analysis must match with an equivalent rounding operation done in PL/SQL on a system associated with the AF database. PL/SQL rounds up when facing a midpoint value. To accommodate that I currently need to add an epsilon to the value before rounding with Analysis so the result will round up in the case of a midpoint Value. Having the MidPointRounding mode option would also make it clear on how the rounding is performed.

According to https://en.wikipedia.org/wiki/Rounding Round-to-even method has served as the ASTM (E-29) standard since 1940. This is also called convergent rounding, statistician's rounding, Dutch rounding, Gaussian rounding, odd–even rounding, or banker's rounding. It is the default rounding mode used in IEEE 754 computing functions and operators because it is favored for scientific computations.

Why do user's want a different rounding method?

Do they want round half-up or round half-away-from-zero?