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 309

1. Add an additional column to the right of the Quantity Sold column by selecting this

column on the table, and then clicking Insert Column After on the toolbar.

2. Click Show/Hide Formula Toolbar to display the Formula toolbar.

To enter a formula by typing you type the formula directly into the Formula toolbar.

3. In the Formula toolbar, type the formula.

For example, to calculate the average revenue generated per item sold, type:

=[Sales Revenue]/[Quantity Sold]

Web Intelligence gives you suggestions for completing the component of the formula

you are typing.

4. To select a Web Intelligence suggestion, press the down arrow button to highlight it,

then press Return.

Select the suggestion with your cursor.

Web Intelligence then adds the component you selected to the formula.

5. If you are in Structure View, click View Results to see the results of the formula.

The formula is added to the report.

NOTE: Formulas always begin with ‘=’ and report objects always appear inside

square brackets in Web Intelligence formulas.

Entering the formula using drag and drop

To enter a formula using drag and drop:

Click this arrow to display the

insert column and insert row menu

options

Web Intelligence gives

the option of selecting

Sales Revenue to

complete the formula