Understanding Formula Columns

You can set up formula column definitions to have the system calculate values based on other columns that you set up. When you set up formula column definitions, you build formulas using existing columns and arithmetic operators for multiplication, division, addition, and subtraction. Each column that you specify in the formula is a segment. You select a segment, then an operator, then another segment. As you select segments and operators, the system shows the formula in the Formula field. You cannot edit the Formula field. If you need to remove a segment or operator from the Formula field, click the Clear Last button to remove the last segment or operator, or click the Clear All button to remove the entire formula.

You can include up to ten segments and nine operators in a formula. You must begin and end the formula with a segment. You can reuse the segments and operators as needed. For example, you can use a ledger type column that you set up for the AA ledger as more than one segment in the formula.