Calculated Columns

Add new columns that are calculated dynamically based on the data in other columns. You can use formulas to perform arithmetic, combine text, or evaluate expressions on every row of the table. This feature is available in both the Simple Table and Simple Table Bodied macros.

How to use

  1. Open the Columns tab in the table setup panel.
  2. Click Add column and enter a formula in the input box. Some examples:
  • firstName
    Pulls the value from the column named firstName as-is for each row.
  • =price * quantity
    Multiplies the values in the price and quantity columns to compute totals dynamically.
  • ="First name" + " " + "Last name"
    Concatenates text strings with a space in between to form a full name column.

You can also customize the column header and data type for the new column. Once created, the formula used in a calculated column is shown in the Accessor section so you can easily review or modify it later.

Supported features

  • Reference any existing column
  • Combine multiple fields
  • Perform arithmetic operations
  • Use string templates
  • Automatically detect or force column data type
Use case: Real-time revenue calculation
avatar

Revenue Ops

Shinkansen Systems — Business Intelligence

Context and goal:
The team tracks customer orders with columns for Unit Price and Quantity, but needs a real-time field showing the total value per order without editing the source file.

Solution:
They add a new calculated column with the formula =UnitPrice * Quantity. This dynamically calculates revenue per row as data is added or updated.

Impact:
The finance team gains an up-to-date, consistent view of revenues without spreadsheets or manual effort. Reports are faster, and errors are reduced.

Calculated columns are especially useful for building dashboards, combining structured and derived fields, or cleaning up inconsistent data before presentation.