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?
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 ).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.