Round

Description

Rounds a number to the nearest integer.

Calculation Editor

Options

Input Parameter Values Input Values
Digits Literal Whole Number (Required)
Divisor Column or Literal (Required)
Midpoint Option Round Up or To the nearest even (Banker's rounding)
Only Rollup If Generic Criteria

Input

Input Input Values Required
Input 1 Column or Literal ✔

Remarks

  • Default behavior is no decimal places (Digits), divisor of 1 and midpoint option of Round Up.
  • Divisor: This will divide your value by whatever number the divisor states (default is 1)
  • "To the nearest even" is only related to numbers that have .5, otherwise, rounding will work as usual.

Examples

Example 1

  1. Input: 3.49
  2. Quick Calculations > Math > Round
    1. Default Selections: Round Up
  3. Output: 3

Example 2

  1. Input: 3.50
  2. Quick Calculations > Math > Round
    1. Default Selections: Round Up
  3. Output: 4

Example 3

  1. Input: 2.50
  2. Quick Calculations > Math > Round
    1. Change Rounding Behavior: To the nearest even (Banker's Rounding)
  3. Output: 2

Example 4

  1. Input: Input 1 Column (3.51)
  2. Quick Calculations > Math > Round
    1. Default Selections: Round Up
  3. Output: 4