Formula Field, Column Layout Table
Specifies a formula. The result of the formula will appear in the column when the account schedule is printed.
You can use this field to perform calculations on other columns. Other columns are referenced through their column number.
You can use the following symbols:
+ (addition)
- (subtraction)
* (multiplication)
/ (division)
^ (exponentiation)
() (parentheses)
% (percent) - If used between two terms, the result is the same as for / (division), but multiplied by 100. When used at the end of a formula, (where the formula only contains one term) the amount from the most recent line with Totaling Type = Set Base for Percent is used as the second term. The first term is then divided by the Set Base for Percent result. The resulting amount is multiplied by 100, and then displayed followed by the percent sign.
You can enter a maximum of 80 characters, both numbers and letters.
Tip
For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.
Parent Tables
| Table | Location |
|---|---|
| Column Layout Table | General Ledger |
| Column Layout Table | General Ledger |