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 339
For more information on using functions as part of custom calculations, see ”Creating
custom calculations” on page 307.
You can see a full list of the functions available in Web Intelligence in the Formula Editor,
or by referring to the Index of Web Intelligence Functions in the online help. For more
detail on the Variable Editor, see ”Creating, editing, and deleting variables” on
page 343.
Function examples and descriptions
This section shows how to use some of the functions available with Web Intelligence to
answer typical business questions. For full information on all the functions available in
Web Intelligence, see the online help.
Example: Calculating a percentage using the Percentage function
Web Intelligence has the Percentage function for calculating percentages. This function
calculates the percentage of a number in relation to its surrounding context. For example,
the following table shows revenues by year and quarter. The Percentage column
contains the formula:
Percentage ([Sales Revenue])
In this case the function calculates each revenue as a percentage of the total revenue. The
surrounding context is in this case the total revenue; this is the only revenue figure that is
relevant outside the breakdown by year and quarter in the table.
If the report is split into sections by year, the surrounding context outside the table becomes
the total revenue in the section.