# Calculations (Calculated columns)

In this section, you can create and configure calculated columns in Finance Tables.

Calculated columns allow you to define your own values based on existing columns and calculations.

### **Make a calculated column**

* **Make a calculated column:** Add a new calculated column to the table.

After creating a calculated column, you can configure it in the same way as other fields in the Data tab.

#### **Column display name**

* **Column display name:** Change the name shown in the table.

#### **Calculation output type**

Choose the type of value your calculation should return:

* **Measure**
* **Dimension**
* **Date**

The available formatting and property options depend on the selected output type.

If the calculation returns a:

* **Measure:** See [Measures](/finance-tables/configuration/configuration-screen/data-tab/measures.md)
* **Dimension:** See [Dimensions](/finance-tables/configuration/configuration-screen/data-tab/dimensions.md)
* **Date:** Use the date formatting options in the configuration screen

### **Calculation placement**

Choose where the calculated column should be placed:

* **Standard column**
  * A standard column behaves like a regular column in the table.
* **Pivot member**
  * A pivot member calculation is added inside the pivot structure instead of as a regular column.
  * When **Pivot member** is selected, you can define where the calculated member should be inserted in the pivot hierarchy.
    * **Auto (deepest)**
    * **Specific pivot level**

This option is only available when pivot mode is active.

***

### **Calculation**

Use the calculation editor to define the formula for the calculated column.

Type **@** to get a dropdown of available columns.

#### **Simple calculations**

You can use calculated columns to perform simple mathematical calculations.

For example:

```
SUM(Profit) / SUM(Sales)
```

This is useful when you want ratios or percentages to aggregate correctly in the table.

#### **If-Else Formula Editor**

Calculations also have access to the **If-Else Formula Editor**.

* **If-Else Formula Editor:** Open the visual editor for building If / Else logic.
* **Clear:** Clear the current calculation.

#### **Using @ in formulas**

The **@** symbol can be used to insert available columns into the formula.

This works in the calculation editor and in the If-Else Formula Editor.

#### **Calculation functions**

Finance Tables supports standard mathematical calculations and other functions.

Examples include:

* **Brackets ()**
* **ROUND**

#### **Pivot functions**

When working with pivoted data, Finance Tables supports pivot functions such as:

* **PIVOT\_SUM**
* **PIVOT\_MAX**
* **PIVOT\_MIN**
* **PIVOT\_AVG**

These functions use the visible pivot values dynamically in the table.

This is useful when you want to calculate values across the pivot members of a row, for example:

* row totals
* averages across periods

**Example: create a row total as an extra pivot member**

```
PIVOT_SUM(Sales)
```

<figure><img src="/files/3L6sBlSb3E4wMq41I7MZ" alt=""><figcaption></figcaption></figure>

#### Using **COL(...)**.

Use **COL(...)** when you want to reference one specific pivoted value directly in your calculation.

This is useful when you want to calculate with a specific pivot member, instead of aggregating across all visible pivot members.

**Example: use one specific pivot value in a calculation**

```
COL([Sales (First Class)]) - COL([Sales (Same Day)])
```

In **Pivot member** mode, typing **@** in the calculation editor will also suggest pivot functions and helpers such as **COL(\[...])**.

#### **Formatting and properties**

After creating the calculation, the available formatting and property options depend on the selected output type.

For example:

* a calculated **Measure** uses the measure formatting and measure properties
* a calculated **Dimension** uses the dimension formatting and dimension properties
* a calculated **Date** uses the date formatting options

<br>

<br>


---

# 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.infotopics.com/finance-tables/configuration/configuration-screen/data-tab/calculations-calculated-columns.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.