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

Adding Computed Items

You can rank and provide statistics for the values represented in the totals or subtotals in your Table section. The Add Computed Item feature enables you to build equations to compute totals, or to apply functions to existing values. Computed items are like normal data items and can be included in reports or reused to compute other data.

For example, you can modify an Amount Sold item by building an equation around it, multiplying by a Unit Price item, and renaming the resulting item Revenue. You can also apply a scalar function such as Cume to Amount Sold and return each individual value as a cumulative running total, or simply multiply Amount Sold by the local tax rate to find the tax owed on each sale.

The Computed Item dialog box is used to build a computed item expression. The computed item expression is a value, variable, logic statement, or equation that instructs how to perform a computation.

To create a computed item:

  1. Choose Table then Add Computed Item.
  2. The Computed Item dialog box appears.

    Computed Item dialog box

  3. In the Name field, type a name that describes the computation.
  4. The default name is Computed, which is numbered sequentially if there is more than one. If you assign a name to a computed item that is identical to an existing scalar function name, the name starting with the number 2.

  5. Define the new data item by building an expression in the Definition text box.
  6. Use the operator buttons to insert arithmetic and logical operators at the insertion point.

    • Click Reference to display the Reference dialog box, and select Request items to place in the equation.
    • Click Functions to apply scalar functions using the Functions dialog box.
    • You can also type any portion of the equation or the entire equation directly into the Definition text box using JavaScript. The names are case sensitive, and you must replace spaces in item names with underscores (‘_’).

  7. If necessary, click the Options button to set a new data type for the item.
  8. When the equation is complete, click OK.
  9. The computed item is added to the Outliner and appears as a column in the table.

Home  |  Previous |  Next  |  Index |  Glossary

Privacy/Legal | Copyright 2002 Brio Software, Inc.