Formula

Formula to Apply

Enter the formula that the system applies to the column. 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].

Factor To Apply

Enter a value that exists in the Factor to Apply (74/FR) UDC table to specify how the system displays positive and negative numbers.

Show Total

Select to show a total for the section.