cancel
Showing results for 
Search instead for 
Did you mean: 
RADSr
Partner
Partner
Status: New

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.    

RADSr_0-1665010569904.png

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.   

RADSr_0-1665016745206.png

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

 

1 Comment
RADSr
Partner
Partner

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 ).