Rounding rule setting?

[RADSr]

I wanted to double-check my assumptions about the formula column, so I plugged the formula into the insight and carried it out to 30 places.    

Editing to add a larger data sample.    Support is "doubling" down on this being a data type issue, but even if it is a data type issue the results below indicate that it's predictable ( even numbers before the decimal are being rounded down while odds round up ) and should therefore be controllable.   

@JoeM  - is there a way to either convert this into a product idea or just replicate this thread under that heading?   

[RADSr]

Support has confirmed that this is not a data type issue and is a rounding rule issue.

Can we please make the rounding rule configurable?   

The default of "half even" is fine, but I need to be able to apply the rule the customer expects ( **especially** for comparisons to the same data in Excel ). 

[RADSr]

Bump

[RADSr]

Since this came up again at a customer today ( 11/8/23  ) I'm going to give this another bump.

[JoeM]

@RADSr  - I'll share this with the team today. 

Not that this should be the solution, but I was able to get a possible workaround.

For the third column, I created the formula:

round(

Percent.Percent.Percent * 100

)

Then put a % suffix on the number.