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

Using alerters to highlight key results296
• Report cells containing sales revenue results that are less then 20% above the average
revenue, display in blue.
Note that this alerter covers values also covered by the first alerter. For example, if the
average is 100, then 79 is both > 80% below the average and < 20% above the
average. In this case, the first alerter takes precedence.
• Report cells containing sales revenue results that are greater than 20% above the
average revenue, display in green.
The average sales revenue result for the three-year period included in the table is $263,
678. When the alerter is applied to the quarterly sales revenue results per product line,
Web Intelligence applies each sub-alerter in the order they appear on the Alerter Editor.
The report looks like this:
This enables you to see at a glance which product lines are generating above or below the
total average sales revenue.
This section of this guide tells you how to use the formula language to:
• build a formula that specifies the condition(s) on which the alerter is based
• display a text, formula, or hyperlink on report cells when the condition(s) of the alerter
are met