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

Saving formulas as variables348
In this example, your initial report looks like this:
Creating an Average Sold variable
To create an Average Sold variable:
1. Click Show/Hide Variable Editor.
The Variable Editor appears.
2. In the Formula pane, type the formula:
Average([Quantity Sold] In ([Quarter])) In Report
Or
Double-click items on the Data, Functions, and Operators tabs to the Formula
pane to build the formula.
3. Set the formula qualification to Measure.
4. In the Name text box, type:
Average Sold
5. Click OK.
Creating a Number of Observations variable
To create a Number of Observations variable:
1. Click Show/Hide Variable Editor.
The Variable Editor appears.
2. In the Formula pane, type the formula:
Count([Quantity Sold] In ([Quarter])) In Report
or double-click items on the Data, Functions, and Operators tabs to the Formula
pane to build the formula.
3. Set the formula qualification to Measure.
4. In the Name text box, type:
Number of Observations
5. Click OK.
Creating a Difference Squared variable
To create a Difference Squared variable:
1. Click Show/Hide Variable Editor.
The Variable Editor appears.
2. In the Formula pane, type the formula:
Power(([Quantity sold] - [Average Sold]);2)