# Round a Column's Values

### 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.

<details>

<summary><code>round the table's "column-name" column</code></summary>

#### 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
```

</details>

<details>

<summary><code>the decimal digits is n</code></summary>

#### 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
```

</details>

<details>

<summary><code>the blank value is x</code></summary>

#### 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
```

</details>

### 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
```