Define calculated columns

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

Learn how to:

• Add calculated columns
• Edit calculated column settings
• 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:

   • 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.
   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.

   • 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.

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.