Cognos - Custom Calculations

Cognos – Custom Calculations

You may add customized calculations to your report as per the enterprise requirement. With the assistance of operators, totally different calculations may be added like if you wish to add a brand new worth wage*0.2 as a Bonus.

To create Calculations in a Report −

  • Choose the merchandise within the report.
  • Click on the insert calculation button and choose the calculation to carry out.

Notice − Calculations that aren’t relevant to the objects you chose are greyed out.

Insert Calculations

To alter the order of the operands or the title of the calculated merchandise added to the report, click on Customized. The calculation seems as a brand new row or a column in your report.

Custom

Drilling

Drill up and drill down is used to carry out evaluation by shifting between ranges of data. Drill down is used to see extra detailed info to lowest stage and drill up is used to match the outcomes.

To drill down or up in a single row or column, pause the pointer over the label textual content till the icon with the plus signal (+) and caret drill down drill up icon seems and the textual content is underlined, after which click on.

To drill down or up in each a row and column concurrently, click on on the worth on the intersection of the row and the column, after which click on once more.