TO_DECIMAL Precision in HANA

No planeada

Jim Ethell

• 13 de abril de 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

• Comentario oficial

  

  Rasmus Jensen

  • 24 de octubre de 2017 16:33

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

  Chris Best

  • 31 de mayo de 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?

Iniciar sesión para dejar un comentario.