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

Building Reports Using the Web Intelligence Java Report Panel 311

The Formula Editor shows the report objects, functions and operators that you can use

to build a formula.

NOTE: To make your formula easier to read, you can use the Ctrl+Enter or

Alt+Enter keys to insert line breaks.

Building a formula using the Formula Editor

To build a formula, using the Formula Editor:

1. Select the cell on the report where you want to include the formula.

You can select a table cell or a free-standing cell.

2. Display the Formula toolbar and the Formula Editor.

See ”Displaying the Formula Editor” on page 310, above.

3. On the Data, Functions and Operators tabs, double-click the report objects,

functions and operators you want to include in the formula, or type the formula directly.

For example, to create the formula =

Average([Revenue]), double-click the Average()

function, then double-click the Revenue object.

NOTE: When you double-click a function to include it in a formula, Web

Intelligence places the cursor between the function parentheses.

Including text in cells

The text in report cells always begins with ‘=’ . Literal text appears in quotation marks,

while formulas appear without quotation marks. For example, the formula

Average([Revenue]) appears in a cell as:

=Average([Revenue])

The text “Average Revenue” appears as:

=”Average Revenue”

You can use text alone in a cell, or mix formulas and text by using the ‘+’ operator. If you

want a cell to display the average revenue preceded by the text “Average Revenue”, the

cell text is as follows:

=”Average Revenue: ” + Average([Revenue])

Note the space at the end of the text string so that the text and the value are not placed

directly side-by-side in the cell.

Saving formulas as variables

You can save a formula as a variable in order to re-use it throughout a report. For

information on how to do this, see ”Saving formulas as variables” on page 343.