Understanding Calculation Columns

Calculation columns contain the results of mathematical calculations. You can perform a calculation involving any number of columns.

When you create an application report using the Director, you have the option on the Select Columns form to create calculation columns. From the Director, you can create calculation columns using only the smart field columns that you selected for the section layout.

After the initial design of the report template is complete, you can insert calculation columns. You can create these calculation columns using:

  • Any column from the attached business view.

  • Smart field columns that are included in the section layout.

  • Other calculation columns.

Note: Calculation columns are based on the amount signs (debit or credit) as they appear in the report, not the actual value that is stored in the database.