TO_DECIMAL Precision in HANA

Not planned

Jim Ethell

• April 13, 2017 19:13

We desire to get thousands separators in number in SQL Reports from Function button.  When you use TO_DECIMAL in HANA it provides thousands separators, but it also tacks on .00 at the end of every number.  We have not found a way to remove the .00 from the numbers and it would be nice if this was available.

Vote

0

• Official comment

  

  Rasmus Jensen

  • October 24, 2017 16:33

  This is not something we can control. All decimal formatting is controlled by the SAP SDK Grid
• 

  Chris Best

  • May 31, 2017 15:36

  SQL Server has a similar issue. I was trying to format a decimal place to one decimal (such as 155.5 instead of 155.50) and the Boyum SQL Report added the extra 0.

   

  Can we have a decimal places setting in the SQL Report formatting wizard?

Please sign in to leave a comment.