HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Building Reports Using the Web Intelligence Java Report Panel 257
18
Using standard calculations
Overview
This chapter describes how you can insert standard business calculations in a Web
Intelligence report.
It covers the following areas:
•
the standard calculations that are available in Web Intelligence
• how to insert a calculation into a table or crosstab
• how to insert multiple calculations
• how to remove calculations from a table or crosstab
Working with standard calculations
You can use standard calculation functions to make quick calculations on the data in Web
Intelligence reports. These calculations are available from the Calculations list on the
Report toolbar. You can customize functions and formulas to apply more advanced
calculations on your data. For information on using custom calculations and formulas, see
the chapter ”Creating custom calculations” on page 307. This section describes how you
can insert standard calculations on tables and crosstabs. It also describes how you can
insert multiple calculations.
What standard calculations are available?
You can use the following standard calculations in Web Intelligence reports:
Calculation type Icon Use to...
Sum Calculate the sum of the selected data.
Count Count all rows for a measure object or count
distinct rows for a dimension or detail object.
Average Calculate the average of the selected data.
Minimum Display the minimum value of the selected data.