Add calculated columns in a list

Insert a calculation to make your list more meaningful by deriving additional information from the data source. You can insert calculations in lists that use IBM® Cognos® Analytics data.

About this task

The list must include a measure. For example, the first column displays Products and the second column displays Revenue.

In addition to simple arithmetic calculations, you can perform the following calculations.

% Of
Calculates the value of a selected member as a percentage of another member, for example, fourth quarter as a percentage of the whole year or actual as a percentage of target.
% Change
Calculates the change in value of a selected member as a percentage, for example, growth from year to year or variance from target.

For information about adding Microsoft Excel calculations, see Create a calculated column or row from scratch.

Procedure

  1. Select the headers of the measure columns that you want to use in the calculation.
  2. On the list toolbar, click Insert Calculation and select the calculation that you want to perform.
    Note: Calculations that are not applicable to the items you selected are grayed out.

Results

The calculated column is displayed in the list. You can rename the calculated column. You can also move the calculated column.
Note: To delete a calculation, right-click the calculated column, click IBM Planning Analytics > Delete.