How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

Aggregation Data for Selection Sum scale size

[This topic is migrated from our old forums. The original author name has been removed]

Hi! When I use aggregation data for selection feature to sum several rows with data type decimal(18,6) the result of the sum has scale 2 rather than 6 what I would expect. Is it possible to have the same scale in the sum value as it is in the source values? Cheers, Zsolt
3 CommentsSorted by Newest First
[This reply is migrated from our old forums.]

Re: Aggregation Data for Selection Sum scale size
Hi Zsolt, Just wanted you to know that this is now included in the just released DbVisualizer 9.1. Best Regards, Hans
[This reply is migrated from our old forums.]

Re: Aggregation Data for Selection Sum scale size
Zsolt, The just released 91.2030 BETA version allow setting scale in the aggregation window. Download here: http://www.dbvis.com/download/beta/ Regards Roger
[This reply is migrated from our old forums.]
[Attachment has been removed.]

Re: Aggregation Data for Selection Sum scale size
Zsolt, In the next 9.1 version (planned for August) there is a "Max Scale" setting in the aggregation window. It is used to control the scale for decimal numbers. See image. Regards Roger
Comments to this discussion are now closed!
More topics in Support
See all 1311 topics