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 219
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.
For more details on the extended syntax that you can use with functions, including the
Report and Section keywords, see ”Defining the calculation context” on page 198.
Example: Showing prompt input with UserResponse()