Bankers Rounding/ASTM Rounding

[JHOL]

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!

[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-th...

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.