SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SA: 14 Results pane rounding

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SA: 14 Results pane rounding
Author Message
Mindflux



Joined: 25 May 2013
Posts: 870
Country: United States

Post SA: 14 Results pane rounding Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 8029

Post Reply with quote
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 View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 870
Country: United States

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.