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 349
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:
Difference Squared
5. Click OK.
Creating the Variance variable
To create a Variance variable:
1. Click Show/Hide Variable Editor.
The Variable Editor appears.
2. In the Formula pane, type the formula:
Sum([Difference Squared] In ([Quarter]))/([Number of Observations] - 1)
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:
Va ria nce
5. Click OK.
Adding the variance to the report
To add the variance to the report:
• Select the Variance variable on the Data tab, and then drop the variable onto the
report.