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

Using Web Intelligence functions232
If the Percentage cell is placed outside the table but still inside the section, the surrounding
context becomes the total revenue. In this case the Percentage function calculates the total
revenue for the section as a percentage of the total overall revenue.
Example: Calculating a percentage using the Sum function
You can gain more control over the context in which a percentage is calculated by using
the Sum function. If you divide one figure in a set of figures by the total of those figures,
you get its percentage of the total; for example, the formula
[Sales Revenue]/Sum([Sales Revenue])
gives the sales revenue as a percentage of the total revenue.
In the following table the Percentage of Total column has the formula
Sales revenue]/(Sum([Sales revenue] In Report))
and the Percentage of Year column has the formula
Sales revenue]/(Sum([Sales revenue] In Section))
These formulas take advantage of the extended syntax keywords Report and Section to
instruct the Sum function to calculate the overall total revenue and yearly revenue
respectively.
Example: Highlighting values using the If function