1 Reply Latest reply on May 11, 2011 8:25 AM by philmodjunk

    Display as variable precision

    KelvinChung

      Title

      Display as variable precision

      Post

      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")?

        • 1. Re: Display as variable precision
          philmodjunk

          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.