HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Creating custom calculations308
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 the Show/Hide Formula Toolbar button.
Now, when you select a cell, its formula appears in the Formula toolbar.
The Formula toolbar has the following buttons:
To enter a formula in the Formula toolbar you can:
• type the formula directly
• drag report objects to 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:
Button Description
Open Formula
Editor
Opens the Formula Editor which allows you to
build a formula using a graphical interface
Create variable Allows you to save a formula as a variable
Clear changes Clears all changes made to the formula since the
last save or validation
Validate formula Verifies the formula syntax and replaces the
current formula
a b c d
a. Open formula editor
b. Create variable
c. Clear changes
d. Validate formula