Brio Software
Technical Publications
Home Previous Next Index Glossary
Data Analysis and Reporting with Intelligence Clients

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:

  1. Select a table column and choose Report then Add Computed Item, or click Add Computed Item on the shortcut menu.
  2. The Computed Item dialog box appears.

  3. In the Column Name field, type a name that describes the computation.
  4. The default name is Computed.

  5. In the Item pane, select the Request column from which to compute the new data item.
  6. 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.

  7. Modify the existing syntax of the table column you selected or define a new computed item by building an expression in the Formula pane.
  8. JavaScript to compute data items. The JavaScript engine supported in does not accept European or non-US number formats for computing data items. More information about JavaScript can be found in the Object Model and Executive Information Systems book.

  9. Click OK to apply the definition to the computed item column.
  10. A new computed column is added to the Facts pane in Table Outliner for the selected table.

To add a free form computed item:

  1. Select a table column and choose Report then Add Computed Item, or click Add Computed Item on the shortcut menu.
  2. The Computed Item dialog box appears.

  3. In the Column Name field, type a name that describe the free form computation.
  4. Click the Formula field.
  5. The Formula field is activated.

  6. Define a new computed item column by building an expression in the Formula field and click OK.

Home  |  Previous |  Next  |  Index |  Glossary

Privacy/Legal | Copyright 2002 Brio Software, Inc.