Mindmajix

Query calculations

Query Calculations:

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 use
  • 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

QUERY CALCULATIONS:

Screenshot_316

Screenshot_317

Screenshot_318

Screenshot_319

Screenshot_320

Screenshot_321

 

 

 

 


 

0 Responses on Query calculations"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.