HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Performing On-Report Analysis with Web Intelligence 187
16
Inserting standard calculations
Overview
You can insert predefined calculations into Web Intelligence reports. These predefined
calculations allow you to perform standard business calculations on your data.
This chapter tells you:
•
what predefined calculations you can add to reports
• how to insert and remove calculations
Available predefined calculations
Web Intelligence allows you to add the following predefined calculations:
Calculation Description
Sum
Calculates the sum of the numbers in
the column.
Count
Counts the number of rows. (All rows
in the case of measure objects,
distinct rows in the case of dimension
or detail objects.)
Average
Calculates the average of the
numbers in the column.
Min
Returns the smallest number in the
column.
Max
Returns the largest number in the
column.
Percentage
Displays each row’s data as a
percentage of the total. Web
Intelligence adds an additional row
to the table to hold the percentages.