 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
Mindflux
Joined: 25 May 2013 Posts: 870 Country: United States |
|
SA: 14 Results pane rounding |
|
Hello,
When I'm highlighting a column in the SQL Assistant results pane, the SUM seems to be rounding numbers off?
The sum should be .50c higher than it is. It's a money column, so it should give me a decimal if needed, right?
The AVG will show decimals if needed in that very same popup so I'm not sure where the disconnect is.
|
|
| Mon Mar 09, 2026 11:33 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 8029
|
|
|
|
Indeed, it does some rounding. I confirmed that the function designed for displaying grid cell statistics isn't data type aware, the selection can extend to multiple columns and randomly selected cells (using Ctrl+), for example, it can include strings and dates. That function attempts to avoid showing very long values, it uses conditional formatting based on the value scales. In your example, you encountered an edge case of 100. Had there been any value less than 100, it would have used decimal formatting. With all values above 100, it doesn't format decimal digits. The number of decimal digits shown also depends on the scale of values selected, could be 2 or 4.
|
|
| Tue Mar 10, 2026 8:25 am |
|
 |
Mindflux
Joined: 25 May 2013 Posts: 870 Country: United States |
|
|
|
Is there a way to turn that off, or can one be added? It's difficult to do calculation confirmation when it decides to start playing tricks with the numbers.
|
|
| Fri Mar 13, 2026 2:35 pm |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|