Bankers Rounding/ASTM Rounding

Hello, I'm trying to get a formula that will round numbers per ASTM rounding/bankers rounding. This is also known as round half even. I've seen some previous posts on this but never really saw a conclusive answer.

For example: 2.65 would round to 2.6.

2.75 would round to 2.8

2.74 would round to 2.7

2.79 would round to 2.8

Thanks in advance!

Help

Accepted answers

All comments

TheOC

hey @JHOL

You can use the round function in the formula tool to do this:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Round-Numeric-Values-with-the-Formula-Tool/ta-p/33683

You would just want to specify one decimal place.

Hope this helps,
TheOC

JHOL

The round tool does not allow you to specify this specific type of bankers rounding that I need. It would round 2.15 and 2.25 to 2.2 and 2.3 respectively. I need them to round to 2.2 and 2.2.

fakbarli

Any luck on this?

apathetichell

how many digits - for rounding to tenths you'd use- if mod(round([Field1],.1),2)=0 then round([Field1],.1) else round([Field1],.1)-.1 endif

you'd adjust depending on the digits you want. could this be dynamic - sure. But I'm lazy so I'll hand you that and you can use as you'd want.

apathetichell

deleted (duplicated)

aatalai

@JHOL would 2.66 be 2.7 or 2.6?

apathetichell

@aatalai - depends on the round precision - tenths - that would be 2.6. To hundredth it would stay at 2.66. @fakbarli can use my formula and adjust for their rounding needs.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703