Setting the Significant Digits of Numbers and the Rounding Method

Article Number:040482

You can set the significant digits of numbers and the rounding method for the following fields:

  • Number
  • Calculated (if the date format is set to "Number")

If you have any formula that combines multiple fields, this setting is applied to each field value used in that formula.

  1. Click the App Settings icon (the gear-shaped icon at the upper right of the "View" screen), select the App Settings tab, and then select Misc Settings under Advanced Settings.
    Screenshot: The "App Settings" icon is outlined in red

  2. Set the "Total Number of Digits", "Number of Decimal Places to Round", and "Rounding".
    Screenshot: The "Precision of numbers and calculations" setting

    • Total Number of Digits
      Specify the maximum total number of digits that includes the decimal part, between the integer 1 to 30.
      The number of digits for the integral part can be entered up to the number of the "Total Number of Digits" minus the "Number of Decimal Places to Round".
    • Number of Decimal Places to Round
      Set the significant digits of the decimal part with an integer between 0 and 10.
    • Rounding
      You can select "Round to nearest even number", "Round up", or "Round down" as the rounding method for the decimal part.
      If you select the "Round to nearest even number" option, a fraction smaller than 0.5 will be rounded down, and a fraction greater than 0.5 will be rounded up. A fraction equals to 0.5 will be rounded to the nearest even result.
      The difference between "Round off" and "Round to nearest even number" can be seen when a fraction equals to 0.5. When selecting "Round to nearest even number", numeric values will be round up or round down to the nearest even result.
      Reference: Setting Round Off, Round Down, or Round Up
  3. Click Save on the bottom right side of the screen.

  4. Click Update App at the upper right of the screen.

  5. On the confirmation dialog, click Update App.