To use Cognos product documentation, you must enable JavaScript in your browser.

Using Calculations

Calculations are basic to solving problems and making decisions, and can help you to define the relationships between items of interest. For example, calculations such as rank and percentile help you instantly identify the most significant items in your analysis.

In Analysis Studio, you can specify which subtotals to show and can view summaries and calculations without typing complex expressions.

The calculations available depend on how many columns or rows you select before you click Calculate.

Objects selectedAvailable calculations
A single row or columnrank, show values as a percentage of the total, round or round down values, and show absolute values
Two rows or columnsarithmetic and percentage calculations
Three or more rows or columnsaggregate calculations, such as sum, average, maximum, and minimum
A setall calculations in the Calculate dialog box

You can perform calculations in Analysis Studio by using predefined summaries or item-based calculations .