Insert a query calculation into your report to add a new row or column with values that are based on a calculation. It is used to perform Data Scrubbing.
- You can create calculations to provide your users with calculated values that they regularly usel
- Calculations can use query items, parameters, variables, calculated members, expressions, and expression components, such as functions
- It allows you to create expressions to derive the new data definitions
Procedure:
- Add the following query items to the list report
- Product line, order method, quantity, revenue
- Group on product line , total on quantity, revenue
- From tool box drag the query calculation
- Drop beside the revenue item
- Enter the name as sales tax
- Click on OK
- Develop the following definition
- Revenue * 0.5
- From toolbar click on validate
- Click on OK
Subscribe to our youtube channel to get new updates..!
Frequently Asked Cognos Interview Questions & Answers
Query Calculations: