Allocation Formula Rules
Use the following definition rules when creating your allocation formulas. The allocation validation program checks that your formulas adhere to these rules.
For formula lines A, B and C (operand lines):
- You can enter either an amount or an account in lines A, B and C.
- If you enter an account, child values must have a Constant segment type.
- Parent values may have a Constant, Looping or Summing segment type.
- You can use a Constant segment type with a parent value only if it references a summary account.
- If you use a Looping segment type on the same segment in more than one of the operand lines, you must use the same parent.
- If you use a Looping segment type in your Target line, you must use a Looping segment type on the same segment using the same parent in lines A, B or C.
- To use summary accounts, all segments in your formula must be assigned a segment type of Constant.
For target and offset lines (lines T and O)
- You must enter an account in the Target and Offset lines.
- Detail values must have a Constant segment type.
- Parent values must have a Looping segment type.
- Your Target account must be different from your Offset account.
For the target line only (line T)
- If you use a Looping segment type in lines A, B or C, you must use a Looping segment type on the same segment using the same parent in your Target line.
For the offset line only (line O)
- You can only use a Looping segment type in your Offset line if the corresponding segment type in your Target line is Looping.
- If you use a Looping segment type in your Offset line, you must use the same parent as in your Target line.
See Also
Entering MassAllocation Formula Lines
Assigning Segment Types
Entering a Target Account
Entering an Offsetting Account
Validating MassAllocation and MassBudget Batches