Create Calculation Row

Explanation

Use this activity to create a calculation row in a row template. A calculation is built up by several lines that are executed in the order they are entered. For complicated calculations, where you need to use brackets, several hidden calculation rows can be used that later are calculated and displayed in a new calculation row. The calculation is performed for each column in the report, except for calculation columns where the value in the field Override Row Calculation is Yes. The Layout tab is used for specifying other information that is not a result of a calculation, e.g., font style and indentation.

Prerequisites

Before creating a calculation row, you must have created, copied, or imported a row template.

System Effects

As a result of this activity, a calculation row is added to the row template.

Window

Row Templates

Related Window Descriptions

Calculation Row

Procedure

Use the following procedure to create a calculation row:

  1. Open the Row Template window and find the row template where you want to include a calculation row.
  2. Select Operations/New Row (or double-click on the row) and then select Calculation Row as the type of row you want to create. This automatically displays Calculation Row window.
  3. Specify the Row Name and Description.
  4. If you want the row to be visible in the report, select the Visible check box.
  5. If you want the row to be used for calculating totals in an SGL (superior-grouping level) sorted report, select the Use as Total check box.
  6. If rows containing null values or zero values are to be printed on the report, select the relevant check boxes, Print Null Value or Print Zero Value.
  7. Double click on the first row in the General tab. A default value is displayed in the Operator field. Enter information for the row. Normally, you specify at least two rows in the General tab. On the first row, the Operator is often Add. On the other rows, the Operator can be Add, Subtract, Multiply, or Divide, depending on the type of calculation.
  8. Example: Presume that there are already two data rows in the row template with the identities Revenue and Cost. To calculate the result, the first line has Operator Add, Argument Type Row, and Argument Revenue. (In the data row, the Change of Sign field is 'Yes'.) The second line has Operator Subtract, Argument Type Row, and Argument Cost.
  9. The Layout tab contains default values for the calculation row. You can change the default values. Save the information when finished.