Adding Computed Items

Use the Add Computed Items command to build equations to compute totals, or to apply functions to existing values. Since a report may derive its values from a wide range of data sources (relational database queries, OLAP queries, imported data sets, and local-join queries), you select the Request item that you want to use from the applicable Results section.

To add a computed item:

Select a table column and select Report, then Add Computed Item
The Computed Item dialog box is displayed.
In the Column Name field, type a name that describes the computation.
The default name is Computed.
In the Tables list, select the results set on which to apply the computed item.
In the Columns list, select the column from which to compute the new data item.
Note that the columns available for reference are only the columns that exist in the results set that is the source for the rest of the table.
Modify the existing syntax of the table column you selected or define a new computed item by building an expression in the Formula pane.
Interactive Reporting uses JavaScript to compute data items. The JavaScript engine supported in Interactive Reporting does not accept European or non-US number formats for computing data items. More information about JavaScript can be found in Oracle Hyperion Interactive Reporting Object Model and Dashboard Development Services Developer's Guide, Volume I: Dashboard Design Guide.
Click OK to apply the definition to the computed item column.
A new computed column is added to the Facts pane in the Table data layout for the selected table.

To add a free form computed item:

Select a table column and select Report, then Add Computed Item or click Add Computed Item on the shortcut menu.
The Computed Item dialog box is displayed.
In the Column Name field, type a name that describe the free form computation.
Click the Formula field.
The Formula field is activated.
Define a new computed item column by building an expression in the Formula field and click OK.