Previous  Next          Contents  Index  Navigation  Glossary  Library

Defining Report Calculations

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.

Note: You can assign either accounts or calculations to a row or column set, but not both.

   To define a calculation:

Sequence Operator Operand
10 Enter B
20 + C
30 * A

+ Add
- Subtract
* Multiply
/ Divide
% Percent
ENTER Enter value
MODE The mode of listed values
AVERAGE The average of listed values
MEDIAN The median of listed values
STDDEV The standard deviation of listed values

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.

See Also

Entering Formulas with EasyCalc

Defining Row Sets

Overview of Financial Statement Generator

         Previous  Next          Contents  Index  Navigation  Glossary  Library