Using total in an allocation line weight compute statement

This is an example of using total in a summary or group weight compute statement, a manual override weight compute statement, or a group override weight compute statement to reference a custom total. For the custom total to retrieve the weight values for the dimension overrides, the custom compute statement must override custom total address. The custom total address is replaced by the allocation dimension overrides. You can override any custom total fields in a compute statement. Any field in the business class to which the compute statement is associated is available as an override field.

The compute statement must follow this construction:

(total(GeneralLedgerTotal."SALES", AccountingEntity=AccountingEntity, GeneralLedgerTotal.AccountingUnit=AccountingUnit, GeneralLedgerTotal.EntityYearPeriod=AllocationContext.Period). NetFunctionalAmount)

Where:

Variable Description
Total A total is used.
GeneralLedgerTotal A business view or an address that holds the balances or totals to be obtained.
SALES The custom total that is defined on GeneralLedgerTotal.

See Custom totals.

AccountingEntity An accounting dimension on the GeneralLedgerTotal.
AccountingEntity The compute uses the accounting entity from the allocation line override dimension instead of the accounting entity specified in SALES.
GeneralLedgerTotal.AccountingUnit An accounting dimension on the GeneralLedgerTotal.
AccountingUnit The compute statement uses the accounting unit from the allocation line override dimension instead of the accounting unit specified in SALES.
GeneralLedgerTotal.EntityYearPeriod A period dimension in the GeneralLedgerTotal.
AllocationContext.Period The compute statement uses the period from the context of the allocation run instead of the period specified in SALES.

The compute statement does not have access to the allocation line except for the allocation period where you are processing an allocation. For example, you can reference the allocation period to find headcount for that period.

NetFunctionalAmount A measure in the GeneralLedgerTotal. The compute pulls the Net Functional Amount.
If the compute statement is set up to retrieve weight values for the posting dimensions in a source address, then use this syntax:
 [Dimension]=AllocationContext.SourceDetail.[Dimension]
For example, use this syntax in a compute statement that is set up to retrieve weight values for finance dimension 1:
 FinanceDimension1=AllocationContext.SourceDetail.FinanceDimension1