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 333
is 2, it means “the total revenue of all month 2s”. As a result, the percentages are not the
percentages you expect.
Examples of useful formulas
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 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.