Formula

The system enables the fields on this tab when you select a row type of Formula.

Row Description

Enter text that the system uses to describe the row. The text that you enter appears in the report.

Reference

Enter additional text to describe the row. The text that you enter appears in the row.

Formula to Apply

Enter the formula for the row. The system uses the formula that you enter for each column of the row. Use these conventions:

• Enter sections as Sxxx, where xxx is the section number.

• Enter columns as Cxx, where xx is the column number.

• Enter rows as Rxxxx, where xxxx is the row number.

• Reference cells using both the column and row number.

  For example, enter R0020C01 to refer to the cell at the intersection of row 20 and column 01 for the current section. Enter S003R0020C01 to refer to the intersection of row 20 and column 01 for the third section.

  Note: If you do not define the section, row, or cell, the system uses the current position.

• Use standard arithmetic symbols.

  For example, use + for addition, - for subtraction, * for multiplication, and / for division.

• Enclose the section, column, or row reference in brackets.

  For example, write a formula for adding the amounts in columns 01 and 02 as [C01]+[C02].

Lines After

Specify the number of blank lines that the system inserts in the report. You can specify up to 50 lines.

Include Account Amount in the Total

Specify whether the amount for the row is included in the total for the section.

You might exclude the account amounts from the total if the amount is included in another line. For example, if you have a formula that adds rows 5 and 6, you would likely specify that lines 5 and 6 are excluded from the totals because the amount for these lines was sub totaled elsewhere.