Skip to main content
Solved

Trailing zeros in grid display

  • July 16, 2025
  • 2 replies
  • 43 views
J
Vanguard
Forum|alt.badge.img+2

I need to consistently show 2 decimals, including when the number is a full integer, or only has 1 decimal. Searching the forum I found references to custom_display_format, but I have no idea how/where to implement it.

 

For example, here it should be 2.25, 1.00, 2.00 and 1.50:

Example without trailing zeros

 

Alternatively I could use a calculated field, but converting numbers to strings in sql for this purpose would be inefficient (and a lot of extra work and complexity), so I'd like to avoid it.

Best answer by Nathan

Hi ​@jkruter, I attempted to replicate the above scenario using a numeric data type with the scale set to 2;


 and when I enter 1.00 as a value then it sill displays the 2 decimal points as part of the output value. Please clarify which data type you are using in your example.

Geurt
This topic has been closed for replies.

2 replies

Nathan
Community Manager
Forum|alt.badge.img
  • Nathan
  • Community Manager
  • Answer
  • July 21, 2025

Hi ​@jkruter, I attempted to replicate the above scenario using a numeric data type with the scale set to 2;


 and when I enter 1.00 as a value then it sill displays the 2 decimal points as part of the output value. Please clarify which data type you are using in your example.

J
J
Vanguard
Forum|alt.badge.img+2
  • jkruterVanguard
  • Author
  • Vanguard
  • July 22, 2025

Hi ​@Nathan, thank you for looking into it!

I was using a decimal:
 

As far as I can see there is no functional difference, other than that decimals might allow number bigger than 6 characters, somehow.

 

I changed it to NUMERIC, and it works just like you said, thanks!

Nathan
Terms & ConditionsCookie settingsAccessibility statement