Rounding Number Fields

You can round number fields, up, down or to the number of places before or after the decimal.

  1. Right-click and select Properties to display the Properties dialog. Select the Round tab.
  2. Specify this information:
    Rounding Method
    Select the rounding method required. The three basic rounding methods are supported:
    • Round to Nearest

      The most common rounding method where values are rounded up or down to the nearest number before or after the decimal.

    • Round up

      Both negative and positive numbers are rounded to the nearest number away from zero.

    • Round down

      Both positive and negative numbers are rounded to the nearest number towards zero.

    Number of Digits
    Select this radio button and use the adjacent fields to specify a value to round by. For example:
    1. a value of 2 rounds 2767.345 to 2767.35
    2. a value of -2 rounds 2767.345 to 2800
    3. a value of 'c' uses the currency number of decimals for the field.
    Multiple Units
    Select this radio button and use the adjacent field to specify that the calculation is to the nearest defined unit. For example:
    1. a value of 3 rounds the number 10 to 9
    2. a value of 3 rounds up the number 10 to 12
    3. a value of 0.05 would round 2.36 to 2.35.
    Reverse Negatives
    Check this check box to reverse the direction for the rounding of negative numbers. For example:

    If selected -2767.345 would round up to -2767.34.

  3. Save your changes.