---
title: "Define calculated columns"
slug: "define-calculated-columns"
description: "Create, edit, and delete calculated columns."
updated: 2023-11-24T14:38:28Z
published: 2023-11-24T14:38:28Z
canonical: "docs.zilliant.com/define-calculated-columns"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zilliant.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Define calculated columns

Some IQ Interface worksheets contain calculated columns. You can recognize calculated columns by the green bar under the column header.

![Columns.png](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/Columns%282%29.png?sv=2026-02-06&spr=https&st=2026-11-12T13%3A20%3A12Z&se=2026-11-12T14%3A20%3A12Z&sr=c&sp=r&sig=Eb8yC93fsHD0yR8SG5W%2BNl8c2XnuesnsbD7N2wHuHnc%3D)

Learn how to:

- [Add calculated columns](/v1/docs/define-calculated-columns#add-calculated-columns)
- [Edit calculated column settings](/v1/docs/define-calculated-columns#edit-calculated-column-settings)
- [Delete calculated columns from a worksheet](/v1/docs/define-calculated-columns#delete-calculated-columns-from-a-worksheet)

## Add calculated columns

1. In a worksheet, select **Column and KPI Settings**.
2. On the **Column** tab, select **Manage Columns**, then select **New Calculated Column**.
3. In the **Column settings** dialog, on the **General** tab, enter or select values:

          Note

          

You can select any column as a variable in the formula expression by clicking its name in the **Fields** list​. For more details about specifying formula expressions, read [About formula expressions](/v1/docs/formula-expressions).
  - **Column name**—Enter a name that describes the calculated content of the new column.
  - **Display Format**—Select the display formatting of the calculated results. It can be **Float**, **Integer**, **Percentage**, or **Currency**.
  - **Column definition**—Enter a formula expression.
  - **Description**—Optionally enter a description for the new column and its calculation details.
4. In **Column Settings**, on the **Column Highlighting** tab, optionally configure [column highlighting](/v1/docs/highlight-columns-and-fields).
5. Select **Save**.
6. Drag the newly-added column's header label to the position you want in the worksheet.

## Edit calculated column settings

1. In a worksheet, select **Column and KPI Settings**.
2. On the **Column** tab, select the column you want to edit.
3. Make changes in **Column settings**, then select **Save**.

## Delete calculated columns from a worksheet

There are two different ways to remove calculated columns from a worksheet.

#### Hide a column but keep it in the worksheet

1. In a worksheet, select **Column and KPI Settings**.
2. On the **Column** tab, toggle **Show** on the column name.

#### Permanently delete a column from the worksheet

1. Select **Column and KPI Settings**.
2. On the **Column** tab​, select the column you want to delete.
3. In **Column settings**, select **Delete**.

Contains values that are the calculated results of formula expressions. The calculations are often applied to values in other columns in the same worksheet. When you make changes to values in the worksheet, all calculated columns are automatically re-calculated and updated with new results.

May be calculated from any combination of basic mathematical operators ( + - * / ), common SQL functions, and language expressions.

![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Glossary/table_60(1).png?sv=2026-02-06&spr=https&st=2026-11-12T13%3A20%3A12Z&se=2026-11-12T14%3A20%3A12Z&sr=c&sp=r&sig=Eb8yC93fsHD0yR8SG5W%2BNl8c2XnuesnsbD7N2wHuHnc%3D)

Column and KPI Settings

![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Glossary/preview_60(2).png?sv=2026-02-06&spr=https&st=2026-11-12T13%3A20%3A12Z&se=2026-11-12T14%3A20%3A12Z&sr=c&sp=r&sig=Eb8yC93fsHD0yR8SG5W%2BNl8c2XnuesnsbD7N2wHuHnc%3D)

Show