Cognos - Custom Calculations

You can add custom calculations to your report as per the business requirement. With the help of operators, different calculations can be added pke if you want to add a new value salary*0.2 as a Bonus.

To create Calculations in a Report −

Select the item in the report.

Cpck the insert calculation button and select the calculation to perform.

Note − Calculations that are not apppcable to the items you selected are greyed out.

To change the order of the operands or the name of the calculated item added to the report, cpck Custom. The calculation appears as a new row or a column in your report.

Drilpng

Drill up and drill down is used to perform analysis by moving between levels of information. Drill down is used to see more detailed information to lowest level and drill up is used to compare the results.

To drill down or up in a single row or column, pause the pointer over the label text until the icon with the plus sign (+) and caret drill down drill up icon appears and the text is underpned, and then cpck.

To drill down or up in both a row and column simultaneously, cpck on the value at the intersection of the row and the column, and then cpck again.