2 Replies Latest reply on Apr 22, 2015 3:33 PM by JacquiProut

    Revise the decimal places



      Revise the decimal places


      I have a very simple calculation field but the result returned is showing about 8 decimal places and I only want to show one decimal place

      How do I do that 

      Thanks for any help


        • 1. Re: Revise the decimal places

          You can show only one decimal place if you select the field while in layout mode and use the numeric data formatting options at the bottom of the inspector's tab to specify only a single decimal place. This will result in a value of 10 displaying as 10.0.

          Or you can round the actual value computed to a single decimal place using the round function:

          Round ( Your calculation expression goes here ; 1 ) will round the value computed to one decimal place. A value of 10 will still display as 10, but a value of 3.1415 will display as 3.1.

          • 2. Re: Revise the decimal places

            Thansk PhilMod, I knew it would be simple the Data forrmating tab was collaspsed I hadn't even noticed it tucked away at the bottom, I just tried its made the figures %.  Something I have done I am sure so will look with fresh eyes and head in the morning