Adding Columns for Calculated Amounts

The components that you set up in the OVFS feature retrieve account balances from the F0902 table. For many financial statements, those are the only account balances that you will include in the financial statement. However, you might need to design financial statements that show the relationship between the account balances retrieved from the F0902. For example, you might need to see the change in the balances from one year to the next, or the percentage of change between periods.

You can set up columns in the Layout Editor to perform the calculations on the account balances retrieved from the F0902 so that you can show the relationships between the account balances. You can set up the Layout Editor columns to perform basic math functions, such as subtraction and division, and to perform other functions.

To add columns for basic math calculations:

1. Place the column for which you apply the calculation into the layout pane.

   For example, if you want to create a column to show the difference between the current month and last month account balances, place the column with the current balances into the layout pane.

2. Select the column in the layout pane.

   When you select the column, the Layout Editor opens the Column tab.

3. On the Column tab, click the Define Custom Formulas icon in the Formula section of the tool bar.

   The Layout Editor opens the Function window.

4. On the Function window, select the function to use.

   The system open the function panel and includes the name of the column that you placed in the layout pane in the first and second fields of the panel. The field names differ for each basic math function.

   For example, if you selected the Subtraction function for the Current Period column, the system shows the name Current Period in the Minuend field and in the Subtrahend field.

   The field names have associated radio buttons.

5. In the Function window, select the radio button of the second field to enable the parameters for that field.

6. In the Parameters section of the Function window, select the column that provides the balances that you perform the action on.

   For example, if you selected the Division basic math function, you select the column that is the divisor for the dividend that you selected at the beginning of this set of steps.

7. Click OK to apply the math function to the column.

For step-by-step examples of creating columns with calculations, see the following sections:

Balance Sheet Case Study: Add Calculated Columns to the Layout

Consolidated Income Statement Case Study Task: Add the Percent of Revenue Columns.

Consolidated Income Statement Case Study Task: Add the Percent of Change Calculated Column.