Originally posted 3/30/2017 7:20:17 PM UTCThe current function "Round()" implements banker's rounding. User's would also like a function that implements standard rounding.
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?
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.
Thank you for your detailed explanation of your use case. This work item is currently in our backlog and has not been assigned to a particular release. Once we have assigned this to a release, we will update the status.
Retrieving data ...