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 197
To find out more about Web Intelligence functions, see ”What is a function?” on
page 229.
About operators
Operators link the various components in a formula. Formulas can contain five kinds of
operators:
• Mathematical
• Conditional
• Logical
• Context
• Function-specific
You can see all the operators supported by Web Intelligence by clicking on the Operators
tab in the Formula Editor.
The following sections describe each type of operator.
Mathematical operators
Mathematical operators are familiar from everyday arithmetic. There are addition (+),
subtraction (-), multiplication (*), division (/) operators that allow you to perform
mathematical operations in a formula. The formula:
[Sales Revenue] - [Cost of Sales]
contains a mathematical operator, in this case subtraction.
When used with character strings, the ‘+’ operator becomes a string concatenation
operator. That is, it joins character strings. For example, the formula
“John” + “ Smith” returns
‘John Smith’.
Conditional operators
Conditional operators determine the type of comparison to be made between values. The
following table describes them:
Operator Description
= Equal to
> Greater than
< Less than
>= Greater than or equal to
<= Less than or equal to
!= Not equal to