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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-a-column/round-a-columns-values.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.