When you create a computed column, you build or create an expression that indicates how to calculate data. When you build an expression to create a computed column, first select a category, then select a function to use to compute the data. Interactive Viewer provides an expression builder containing categories with functions and operators that you use to create, modify, and view expressions. You can select the columns across which to perform the calculation. Figure 6-2 shows an example of building an expression to calculate the extended price, which is not included in the report.
Figure 6-2 If you are already familiar with writing expressions, you can create custom expressions to insert computed columns in a report. In the example, as shown in Figure 6-3, you multiply each value in the QUANTITYORDERED field with the corresponding value in the PRICEEACH field, to obtain the value in the Total column. The following expression calculates the Total:
Figure 6-3
|
|
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy |
BIRT iHub 2 |