Calculations in Query Studio |
You can perform many types of calculations in Query Studio. For example, you can calculate the sum or average of the values in one column, or multiply the values in two columns.
Calculation results are not stored in the underlying data source. Instead, Query Studio reruns the calculation each time you run the report. The results are always based on the most current data in the data source.
Note: The functions available when creating calculations are restricted by functions available in the data source.
You can perform calculations in Query Studio by adding summaries or by adding calculations.
Use the Summarize command to add or remove footer values, or to change how detail values are calculated. For example, use the Summarize command to place an average in each footer. For more information, see Adding a Summary to a Query Studio Report.
Use the Calculate command to create new report items using data from one or more report items. For example, use the Calculate command to add together several columns in a list report. For more information, see Adding a Calculation to a Query Studio Report.
Related Topics: