Understanding Calculation Columns

Application reports enable you to define calculation columns. Calculation columns display the results of a calculation involving two or more smart field columns or other calculation columns. In a report that is created using a Director template, the Director recognizes only the smart fields that are attached to the template; therefore, business view fields that are included in the section layout cannot be used in calculations. After you complete the design process using the Director, you can use RDA to add calculation columns based on other columns in the report.

Note: Values in calculation columns are based on the amounts that appear in the report, not on actual values that are stored in the database.

These calculation types are available when you are creating calculation columns:

• Difference between

  Presents two operand fields. Use the field drop-down list boxes to select the columns to use for calculating the difference between columns.

• Percent variance between

  Presents two operand fields. Use the field drop-down list boxes to select the columns to use for calculating the percent variance between columns.

• Undefined

  Creates a numeric variable column in the report section for which you can manually define a calculation. Select the column variable in RDA, and select Define Calculation from the Column menu.

• Total of

  Presents columns from the report layout. Click each field to be included in the total.

• Product of

  Presents two operand fields. Use the field drop-down list boxes to select the columns to use for calculating the product of columns.

See also:

• Creating Calculation Columns.