Examples
upper (’Auriga’)
Returns the result: AURIGA
upper (’DeEr’)
Returns the result: DEER
Aggregate Functions
Executes a predefined function and returns an aggregate for a set of values based
on the function values.
Note: You can access aggregate functions through calculated categories, calculated
measures and dimension calculations. You cannot access them through calculated
columns.
Aggregate Description
Average Returns the average value.
Change Returns the difference over a linear series of categories by
calculating the change between each pair of categories.
Max Returns the maximum value of selected data items.
Min Returns the minimum value of selected data items.
Percent Returns the percent of the total value for selected data items.
Percent-growth
Returns the growth over a linear series of categories by calculating
the percentage change between each pair of categories.
Share Returns the values of categories as a percent share of other target
categories.
Average
Returns the average value of selected data items.
Cognos Transformer supports the Average function with numeric data; the only
parameters accepted are the numeric expressions and the auto component.
Syntax
average (<numeric_exp)
Example
average (Sales)
Returns the result: The average of all Sales values.
Change
Returns the difference over a linear series of categories by calculating the change
between each pair of categories. The order of pairs is based on the object ID of
each category.
Appendix F. IBM Cognos Transformer Expression Editor 371
To Next Page
Loading...
Need help?
General