TO_DECIMAL Precision in HANA Not planned

Jim Ethell

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.

Comments

2 comments

Date Votes
  • Comment author
    Rasmus Jensen
    • Official comment

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

  • Comment author
    Chris Best

    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?

    0

Please sign in to leave a comment.