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 195
NOTE: To display the Report toolbar, click View > Toolbars > Report on the
Main toolbar.
2. Display the Formula toolbar by clicking View > Toolbars > Formula on the Main
toolbar.
3. In the Formula toolbar, type the formula, then click Enter.
For example, to calculate the average revenue generated per item sold, type:
=[Sales Revenue]/[Quantity Sold]
NOTE: Formulas always begin with ‘=’ and report objects always appear inside
square brackets in Web Intelligence formulas.
Using the Formula Editor
You can use the Formula Editor to enter formulas in the Formula toolbar. The Formula
Editor is a graphical interface that you use to build formulas. It contains all report objects,
functions and operators that you can use in a formula.
Displaying the Formula Editor
To display the Formula Editor:
• Click the Formula Editor button on the Formula toolbar.
The Formula Editor appears:
The Formula Editor shows the report objects, functions and operators that you can use
to build a formula.
Building a formula using the Formula Editor
To build a formula, using the Formula Editor: