Financial Statements - Column Calculation dialog
The Column Calculation dialog appears when you are creating or editing a column in a Do-It-Yourself table. This dialog helps define the column properties depending on your requirements.
Tip: To navigate columns, simply click to go the next column and to go to the previous column.
The Select column type: drop down menu located under the Type tab, enables you to specify the calculation type to be used in the column cells. Depending on the calculation type selected, the remaining dialog options will change. The following calculation types are provided:
Populate the cells in the column with input cells, into which users can type values directly. The input type can be useful where data is not derived from the trial balance.
Note: this selection overrides the row’s line source setting.
|Subtotal||Populate the cells in the column a subtotal of other columns in the table.|
|Link mapping/grouping calculation||Populate the cells in the column using the Working Papers Trial Balance values.|
|Custom Calculation||Populate cells in this column with a customized calculation. Use of this calculation type requires an understanding of CaseView formulas. For more information, see the CaseView help topic About Cell Calculations.|
|*MMR only*Annotation||Populate the cells in the column with Add Annotation ( ) buttons.|
|*MMR only* Description||
Populate the cells in the column with the mapping and grouping description.
|*MMR only* Icon Sets||Populate the cells in the column with icon sets based on a set condition.|
|*MMR only* Map Browse||Populate the cells in the column with a map browse drop-down.|
|*MMR only* Blank||Populate the cells in the column to be blank.|
|*MMR only* Variance||Populate the cells in the column with the difference between column 1 and column 2.|
The Variables tab is provided if the column is a link mapping/grouping calculation type.
The Visibility tab is provided for all columns, regardless of calculation type:
|Column type||The format of the values that will be typed into the column. This can be either Numeric or Alphanumeric.|
|Columns||This field lists the columns that can be included in the subtotal. Use Ctrl+click to select the columns to include.|
The following fields are available from the Type tab:
The source of data from the consolidation structure. Select one of the following from the drop-down:
Specify whether to multiply the account balance by the foreign exchange rate or display the rate for a particular grouping number only. Select one of the following from the drop-down:
The rounding value applied to a balance. Select one of the following from the drop-down:
|Unreconciled Difference Column||Apply only the unreconciled difference formatting (red text) to the column. This column can then be set up to behave like the unreconciled difference row.|
|Unreconciled Difference Column||Applies only the unreconciled difference formatting (red text) to the column. This column can then be set up to behave like the unreconciled difference row.|
Type the calculation that you want to use. A valid calculation is highlighted in green, and an invalid calculation is highlighted in red.
If you hover over this field, a tooltip appears that displays the result of this calculation.
Use of this custom calculation requires an understanding of CaseView formulas. For more information, see the CaseView help topic About Cell Calculations.
|Year||The year to use as reflected in the trial balance. Year 0 is the current year, Year 1 is the previous year, and so on. If Balance Type is set to Forecast Balance, all years except Year 0 represent future years, not prior years.|
|Period Date Sequence||The reporting period (bucket) to use. The Default option uses the current period date sequence and current active period set in Working Papers.|
How the period number is to be obtained. The following options are available:
The balance type to use. If this is set to None, the default CaseView balance type is used, which is Balance Consolidated (normal + reclassifying + eliminating).
Selecting Specify calculation allows you to manually enter the value. The entry must be entered with quotations. The input box is outlined in green for valid calculations and red for invalid calculations.
For more details, see the Type section of the CaseView help topic Values.
|Apply other basis adjustments to balance||Select this check box to apply other basis adjustments to the balance. This check box cannot be checked if Balance Type is set to None.|
Select how to further customize the grouping values to be included in the calculation for a column:
How a sign is to be treated during calculation. Select one of the following radio buttons:
|Sample Calculation||Display the compiled calculation of all of the selections made in this dialog. To update this field to include any changes you have made, click Update.|
Indicate when the column will print and display. The following visibility options are available:
|Include variance %||
Select to add a variance percentage column based on the difference between column 1 and column 2.
|Column 1||Select the column that is to be subtracted.|
|Column 2||Select the column that column 1 is subtracted from.|
|Icon||Select from a variety of icons to display based on the condition.|
|When||Enter a valid CaseView calculation and whether the calculation needs to be less than, equal to, or greater than a specified value for the icon to appear. For more information on CaseView calculations, please refer to the CaseView Help.|