Previous | Next | Contents | Index | Navigation | Glossary | Library |
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.
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.
Overview of Financial Statement Generator
Previous | Next | Contents | Index | Navigation | Glossary | Library |