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

Creating Custom Calculations212
You have a report showing Year, Quarter and Sales revenue. The report has a column,
Report Total, that shows the total of all revenue in the report.
The formula for the Report Total column is
Sum([Sales revenue]) In Report. Without the Report
keyword, this column would duplicate the figures in the Sales Revenue column because it
would use the default output context ([Year];[Quarter]). For more information on default
contexts, see ”Default calculation contexts” on page 199.
The Section keyword
The following table describes the data referenced by the Section keyword depending on
where it is placed in a report
Example: The Section keyword
You have a report showing Year, Quarter, and Sales revenue. The report has a section
based on Year. The Section Total column has the formula:
When placed in... References this data...
A block All data in the section
A block break (header
or footer)
All data in the section
A section All data in the section
Outside any blocks or
sections
Not applicable