Rounding a numeric column to integer values

Rounding is a simple way to group together numbers with fractional components. Numeric columns can be rounded to the nearest integer value, or by one of these methods:

• Rounding up (the ceiling function) returns the next-largest integral value
• Rounding down (the floor function) returns the largest integral value less than or equal to the value being rounded
• Rounding towards zero (the truncate function) returns the integer component of the value being rounded

To round a numeric column:

1. In the Summary view, select the column you wish to round
2. Choose Column > Round to Integer, and select the desired rounding method

See also:

• Treating a column as categorical data
• Computing the quantiles of a numeric column

---

Back to Wizard Help