How to Add Calculations in a Data Table

Summary

You can add calculated columns to a data table to perform basic calculations. This allows you to generate additional values before exporting the data or using it in integrations. Calculations do not change the original data, they only create a new value in the table.

NOTE: Calculations in Tabulate is currently being developed and is released in Early access. This means that the feature does not yet have all functionality in place. We suggest you start to explore it on a copy of your tables. Calculations will not change any data. See current limitations below.

If you don't see it in the platform yet please be patient. If you want to try this feature before it's been rolled out to all customers please get in touch with your Position Green point of contact.

Applies To

• Users working with Data tables

• Users preparing data for export

• Users preparing data for BI integrations

How to Add a Calculation to a Data Table

Before adding a calculation, ensure the table contains the data columns you want to reference.

1. Open the data table you want to modify.

2. Add the required data columns to the table.

3. Click Add calculation.

4. Enter a name for the calculation.
   This name will appear as the column header.

5. Enter your formula in the Expression field.

6. Apply the same aggregation type used in the referenced columns.

7. Save the table.

The calculation column will appear at the end of the table.

Referencing Columns in Calculations

Columns are referenced using letters based on their position in the table.

• A = first column

• B = second column

• C = third column

Example:

If column A contains energy consumption and column B contains production volume, you could calculate intensity using:

= A / B

Supported Operators

The following operators are currently supported.

Addition

A + B

Subtraction

A - B

Multiplication

A * B

Division

A / B

Parentheses

Parentheses can be used to control the order of operations.

Example:

(A + B) / C

Adding Numbers

Numbers can be included directly in expressions.

Example:

(A + B) / 12

Aggregation Requirement

The calculation column must use the same aggregation method as the referenced data columns.

Example:

If columns A and B use Sum, the calculation column must also use Sum.

If aggregation differs, the calculation may generate additional rows in the data table.

Current Limitations

The Early Access version includes several limitations.

Column Order Restrictions

After a calculation column is added:

• Existing columns cannot be deleted

• Existing columns cannot be reordered

To modify the table structure:

1. Remove the calculation column

2. Modify the table

3. Recreate the calculation
   
   

Column Reference Direction

Calculations can only reference columns to the left of the calculation column.

Columns placed after the calculation column cannot be used in the expression.

Related Articles

• Create a Data Table 

• Export Data from a Data Table 

• Using Data Tables for BI Integrations