You can define formulas to calculate row or column amounts. For example, you can define a row calculation which sums all of the rows above it in the report. Or, you can define a column calculation which calculates the difference between two previous columns.
Note: General Ledger stores credit balances as negative numbers and debit balances as positive numbers, so you should define your calculations accordingly. For example, if you want to calculate a gross margin row, add (rather than subtract) your cost of sales row to your sales row.
Use the Absolute Value function to display only positive numbers. You can apply the Absolute Value function to balances or calculation results regardless of the underlying debit or credit balance.
Note: You can assign either accounts or calculations to a row or column set, but not both.
When a column contains a calculation that operates on other columns, the XBRL output will be generated but the calculation results will not be present in the output.
For calculated rows with divide operations, ensure the divisor is not zero or determine an alternative for the row. If the divisor is zero for a calculated row with divide operations, the report will be generated but the result of this calculation will not be present in the output.
From the Rows or Columns window, choose Calculations.
Enter a sequence number for each step of your calculation. This controls the order FSG follows when performing the mathematical operations required to complete the calculation.
For example, to calculate a derived row using the formula A(B+C), enter sequence numbers to perform the addition first, then multiply the result by A. The following table shows this calculation:
| Sequence | Operator | Operand |
|---|---|---|
| 10 | Enter | B |
| 20 | + | C |
| 30 | * | A |
Enter the mathematical Operator for each step of your calculation. Valid operators for row or column calculations include:
| Operator | Calculation |
|---|---|
| + | Add |
| - | Subtract |
| * | Multiply |
| / | Divide |
| % | Percent |
| ENTER | Enter value |
| AVERAGE | The average of listed values |
| MEDIAN | The median of listed values |
| STDDEV | The standard deviation of listed values |
| Abs | The absolute value of listed values |
Note: FSG calculation operators are based on EasyCalc - a General Ledger mathematical notation feature.
Enter a Constant, a range of sequence numbers, or the name of a row or column to use in each calculation step.
Constant - Enter a number to use as a Constant value. For example, as part of an earnings-per-share calculation, you might enter the number of outstanding common shares as the constant by which you divide net income.
Sequence Low and High - Instead of a constant, you can enter the Low and High sequence numbers corresponding to the range of rows or columns to use in your calculation.
The Operator is applied to each row or column in the range. For example, if you use the + operator on a range of four rows, FSG will add all values encompassed by the four rows.
Row Name or Column Name - Instead of a constant or a sequence range, you can enter the name of a specific row or column to use in a calculation.
For example, assume you have a report with three columns, representing actual, budget, and variance amounts. The first two columns are named Actual and Budget. When you define the calculation for the variance column you can instruct FSG to subtract the column named Actual from the column named Budget. The result, the variance from budget, will be displayed in the third column of your report.
Note: If you use row or column names in your calculations, make sure the names are unique within the row set or column set to which they belong.
Add as many steps as needed to complete the calculation.