Percent of value

Percent of value allocates an amount across an organization based on each unit's percentage of amount according to specific criteria. For example, allocate Utility Expense based on each unit's percent of the total square footage. This example requires a second consolidation pass because the Square Footage has to aggregate to North America in order to be used as the divisor

If ( LeafDescendantOf( [Unit]:[N. America Consolidated] ) ) then
[Utility Expense] = [Utility Cost] of [Unit]:[N. America Operations] * [Sq. Footage]/[Sq. Footage] of [Unit]:
[N. America Consolidated];
EndIf

This example allocates Marketing Expenses for entire Operations Division to units based on each unit's percent of Net Sales. .

If(LeafDescendantof([Unit]:[Operations])) then
[Allocated Mktg]=[Total Operating Expense] of [Unit]:[Marketing] * [Net Sales]/[Net Sales] of
[Unit]:[Operations];
EndIf