cancel
Showing results for 
Search instead for 
Did you mean: 
RADSr
Captain
Captain
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?   

 

4 Comments
RADSr
Captain
Captain

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
Captain
Captain

Bump

RADSr
Captain
Captain

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

JoeM
Community Manager
Community Manager

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

JoeM_0-1699539991304.png

For the third column, I created the formula:

round(
Percent.Percent.Percent * 100
)
 
Then put a % suffix on the number.
 
JoeM_1-1699540074216.png