List of Allocation Criteria

Allocations are based on a variety of specified criteria. Table 210 provides a brief description of the criteria used to define allocations. Review these terms before continuing.

Table 210. Description of Allocation Criteria

Criteria

Description

See

POV

A symmetric region in the database that describes the context in which allocations are performed

Setting the POV

Range

A symmetric region in the database in which allocated values are calculated and written

Setting the Range

(Optional) Excluded range

Locations in the range where you do not want allocation values written

Setting the Range

Amount

The amount to be allocated

Setting the Amount

(Optional) Amount context

Additional context, or specificity, for the amount

Setting the Amount

(Optional) Amount time span

One or more time periods to be considered for the amount

Setting the Amount

(Optional) Zero amount options

Treatment of zero or #MISSING amount values

Setting the Amount

Basis

When combined with the range, defines the location of basis values that determine how the amount is allocated

Setting the Basis

(Optional) Basis time span

One or more time periods to be considered for the basis

Setting the Basis

(Required if basis time span is set)

Basis time span option

Method for calculating the basis across the basis time span:

  • Combine

  • Split

Setting the Basis

Zero basis options

Treatment of zero basis values

Setting the Basis

(Optional) Negative basis options

Treatment of negative basis values

Setting the Basis

Target

When combined with the range, defines the region in the database where allocation values are written

Setting the Target

(Optional) Target time span

One or more time periods to be considered for the target

Setting the Target

(Required if target time span is set)

Target time span option

Method for allocating values across the target time span:

  • Divide the amount

  • Repeat the amount

Setting the Target

Allocation method

Method for allocating the amount:

  • Share: Allocates the amount proportionately to the basis values

  • Spread: Allocates the amount evenly

Setting the Allocation Method

(Optional) Spread skip options

For spread allocation method, whether to skip basis values in the range that are zero, #MISSING, or negative

Setting the Allocation Method

Rounding method

Whether to round allocated values.

If you choose to round, specifies the method for handling rounding errors:

  • Discard rounding errors

  • Add the total rounding error to:

    • The greatest allocated value

    • The lowest allocated value

    • A specific location

Setting the Rounding Method

(Optional) Round digits

The number of decimal places to which allocation values are rounded:

  • To the nearest integer

  • To a specified number of decimal places

  • To a power of 10

Setting the Rounding Method

(Required if rounding method is set to a specific location)

Round to location

The location to which to add the total rounding error

Setting the Rounding Method

(Optional) Offset

The location in the database where an offsetting value for each source amount is written

Setting the Offset

(Optional) Credit and debit members

In double-entry accounting, balancing journal entries for one transaction

Balancing Allocations