Round a Column's Values

Rounds numeric values in a table column to a specified number of decimal places.

Overview

This procedure rounds the values in a specified column of a table to a given number of decimal digits. It automatically handles comma-separated values and converts non-numeric columns to numeric format before rounding. You can specify the number of decimal places and provide custom handling for missing values.

Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

round the table's "column-name" column

What does it do?

Rounds all values in the specified column.

Where does it go?

This phrase should be written on a new line.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace column-name with the name of the column to round. A reference to the table must be defined in the automation.

Example

round the table's "Age" column

the decimal digits is n

What does it do?

Specifies the number of decimal places to round to.

Where does it go?

Indented under round the table's "column-name" column.

Is it required?

❌ No — This phrase is optional.

Does it require data?

✅ Yes — Replace n with the number of decimal places to round to. If not specified, it defaults to 0 (rounds to whole numbers).

Example

the decimal digits is 2

the blank value is x

What does it do?

Specifies a replacement value for empty cells or null values before rounding.

Where does it go?

Indented under round the table's "column-name" column.

Is it required?

❌ No — This phrase is optional.

Does it require data?

✅ Yes — Replace x with the desired replacement value for missing data.

Example

the blank value is 0

Examples

1. Round Column to Whole Numbers

Rounds decimal values in the "Age" column to whole numbers (no decimal places).

round the table's "Age" column

2. Round Column to Two Decimal Places

Rounds values in the "Tenure" column to exactly 2 decimal places.

round the table's "Tenure" column
    the decimal digits is 2

3. Round Column with Blank Value Handling

Rounds a column while replacing any missing values with 0 before processing.

round the table's "Price" column
    the blank value is 0.00