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 193

Creating Custom Calculations

Overview

Custom calculations allow you to add additional calculations to your report beyond its

base objects and the standard calculations provided by Web Intelligence.

You add a custom calculation by writing a formula that Web Intelligence evaluates when

you run the report. A formula can consist of base report variables, functions, operators and

calculation contexts.

This chapter describes:

•

creating formulas

• functions

• operators

• defining calculation contexts in formulas

• examples of useful formulas

Example: Showing average revenue per sale

If you have a report with Sales Revenue and Number Sold objects and you want to add

revenue per sale to the report. The calculation

[Sales Revenue]/[Number Sold]

gives this value by dividing the revenue by the number of items sold in order to give the

revenue per item.

A custom calculation is a formula that can consist of report objects, functions and

operators. Formulas have a calculation context that you can specify explicitly if you

choose.

For information on formulas, see ”Creating formulas” on page 193. For information an

operators, see ”Examples of useful formulas” on page 218. For information on calculation

contexts, see ”Defining the calculation context” on page 198.

Creating formulas

This section describes the ways in which you can create formulas in your reports. You can

add formulas in two ways:

• by typing the formula components into the Formula toolbar

• by using the Formula Editor to build the formula