Display as variable precision
Is there a way to format a field such that a maximum of 2 decimal places is displayed (not fixed precision, so 85 displays as "85" and 127.5 displays as "127.5", while 0.142857 displays as "0.14")?
No easy way to format it that way, but a calculation field with this expression will work:
Round ( YourField ; 2 )
Note: Changing the format of the data by selecting a data format in the Inspector does not change the value stored in the field. It just changes how the value is displayed. This calculation changes the actual value so you will need to decide whether you need to use the rounded value produced by this calculation or the original unrounded value in any other calculations and/or value comparisons.
Retrieving data ...