Skip to main content
12-Amethyst
Nov 20, 2019 3:49 PM UTC
Question

Format number without meaningful trailing zeros in Advanced Grid or Grid

In the Advanced Grid or Grid configuration, you can specify the number format as "0.00".

This results in 3.1415 being displayed as "3.14", but also 11 as "11.00", and 12.3 as "12.30"

Is there a possible format string to remove unnecessary zero's, so 3.1415 is displayed as "3.14", but 11 is displayed as "11" and 12.3 is displayed as "12.3"?

 

2 replies

20-Turquoise
Nov 20, 2019 4:38 PM UTC

Localization might help with that task: https://www.ptc.com/en/support/article?n=CS271227

Translate
1-Visitor
Nov 22, 2019 8:05 AM UTC

Hi @wvangeem ,

 

You can also consider writing a service to format the numbers before populating the grid with the data. That way you can determine which numbers are displayed with how many decimal numbers.

Translate