HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Performing On-Report Analysis with Web Intelligence 227
6. In the Name text box, type:
Average Sold:
7. In the Name text box, type:
Difference Squared
8. Click OK.
Creating the Variance variable
1. Display the Formula toolbar by clicking View > Toolbars > Formula on the Main
toolbar.
2. Make sure that no cell is selected.
3. Click Create a variable on the Formula toolbar.
4. In the Formula pane, type the formula:
Sum([Difference Squared] In ([Quarter]))/([Number of Observations] -
1)
Or
Double-click items on the Available Objects, Available Functions and Available
Operators boxes to build the formula.
5. Set the formula qualification to Measure.
6. In the Name text box, type:
Average Sold:
7. In the Name text box, type:
Difference Squared
8. Click OK.
Adding the variance to the report
To add the variance to the report:
1. Select the Variance variable under Available Objects on the Left Pane, and then drop
the variable onto the report.