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

Saving formulas as variables226
To create an Average Sold 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:
Average([Quantity Sold] In ([Quarter])) In Report
Or
Double-click items in 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. Click OK.
Creating a Number of Observations 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:
Count([Quantity Sold] In ([Quarter])) In Report
Or
Double-click items in 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. Click OK.
Creating a Difference Squared 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:
Power(([Quantity sold] - [Average Sold]);2)
Or
Double-click items in the Available Objects, Available Functions and Available
Operators boxes to build the formula.
5. Set the formula qualification to Measure.