Allocate

Use this function in an equation to allocate a proportional set of values across another symbol.

Note: Only those symbols to which the user has access will be included in the allocation.

You can specify allocations in the dimension specified in a By statement (for example, By TIMEPER).

Allocate (IntersectSym, PatternSym[, PatternSourceSym][, Precision[, PlugSymName]])

where:

• IntersectSym is a symbol in the BY dimension that intersects with the target symbol. The cell where they intersect is the source value. This source value is a total value to be allocated.
• PatternSym is the symbol that contains the pattern used for the allocation.
• PatternSourceSym is used when the source of the pattern is different than the target symbols in the BY dimension. This symbol specification and the number of symbols must match the number specified in the calculation block.
• Precision is the number of digits after the decimal.
• PlugSymName is the symbol that receives any difference (referred to as the plugged amount) due to rounding. Precision and PlugSymName relate to each other in the following ways:

  If…	Then…
  Precision is not specified	no rounding occurs, and there is no plugged amount to allocate
  Precision is specified but PlugSymName is not specified	rounding occurs, and the highest target value gets the plugged amount
  Precision and PlugSymName are both specified	rounding occurs and PlugSymName gets the plugged amount

A57100 = ALLOCATE (AYR01, A41000, 1, COL3)