How can we help you today? How can we help you today?

Show aggregate result and decimal numbers

Super that you added 'Show aggregate result'! 

Though on my machine it show the wrong numbers when using decimal numbers. See the attched screenshot.

Remko1981
0

Comments

2 comments

Sort by
  • cperez
    Good Morning Remko,

    Thanks for reaching out to Redgate Software, glad you are enjoying the new 'Show aggregate feature' feature, could I kindly have yo elaborate a bit further on what exactly you are attempting to do in this instance?
    cperez
    0
  • Remko1981
    I tried to make an example to show in the most basic way what is going wrong. So the value in the single cell is 2.1 . But when i click 'Show aggregate result' it gives a sum, average, min and max of 21 . It erases the decimal seperator. This also happens when you select multiple rows.

    In the Netherlands we normally use the comma (,) for the decimal seperator. So maybe my regional settings in combination with SSMS messes things up. Excel for instance uses the regional settings correctly(a comma) but SSMS does not it insists on using a dot (.) for the seperator on decimal values.
    Remko1981
    0

Add comment

Please sign in to leave a comment.