.The Transformer expression editor supports a common set of mathematical calculations and a few additional Transformer-specific functions, as explained below.
Note: The Transformer expression editor is not the same expression editor used in Framework Manager or the IBM Cognos 8 Web studios.
When you build an expression, you select elements, one by one, from the Available components list in the left pane of the expression editor and build your expression in the right pane. The available elements vary according to the type of calculation and the position in the expression. Explanations for each element are provided in a Tips window in the expression editor and, as you enter each element, the syntax is evaluated against standard mathematical rules.
Tip: If the Tips box is not visible, click the Tips button .
You can also copy or type your calculation directly into the Expression definition pane.
The supported functions for calculated measures are:
Returns the absolute value.
Returns the average value.
Returns the minimum value of selected data items.
Returns the maximum value of selected data items.
Returns the percent of the total value for the selected data items.
The supported arithmetic operators are + (addition), - (subtraction), * (multiplication), / (division), and ^ (exponentiation).
The Transformer expression editor also supports if-then-else constructs and brackets. The boolean portion of the if-then-else supports AND, OR, and isnull (a function that tests if a measure value is empty).
For more information about the expression editor, see IBM Cognos 8 Transformer Expression Editor.
