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

Creating Custom Calculations194
The first way is more suitable for experienced users. If you are not familiar with formulas,
you should use the Formula Editor to build them. The Formula Editor is an interface that
allows you to select the different components of your formula (that is, operators, objects,
and functions) and add them to it.
Using the Formula toolbar
You display the Formula toolbar by clicking View > Toolbars > Formula on the main
menu. Now, when you select a cell, its formula appears in the Formula toolbar:
The Formula toolbar has the following buttons (from left to right):
Typing a formula into the Formula toolbar
Example: Calculating the average number of items sold
You have a report showing Year, Quarter, Sales Revenue and Quantity Sold and you want
to add an additional column that shows the average revenue generated per item sold. The
formula that gives this is:
=[Sales Revenue]/[Quantity Sold]
Entering a formula by typing
To enter a formula by typing:
1. Add an additional column to the right of the Quantity Sold column by selecting this
column on the table, and then Insert > New Column > Right on the Report toolbar.
Button Description
Create a variable/
Edit a variable
Create New Variable/Edit variable dialog box.
• If the selected cell does not contain a variable
or if there is no cell selected, the Create a
variable button is displayed (shown in the
toolbar on the left).
• If the selected cell contains a
previously-created variable, the Edit variable
button is displayed (shown in the toolbar on
the right).
Formula Editor Opens the Formula Editor
Validate formula Verifies the formula syntax
Cancel formula Clears the formula