Configure Accounts to use Global Sum Methodology

Use this section of the 20 Global Sum driver to define which accounts receive values calculated by the Global Sum methodology and how those values are applied. Each row identifies a destination account and specifies which Account Summary Group or Groups to use as the calculation base, along with the adjustment factor applied to each group.

This section uses the Summary Groups defined in Configure Revenue Accounts to be Summed and applies percentage-based results to accounts on the Stat_Rev or Expense tab. When the underlying Stat_Rev values change, the calculated results update automatically.

Insert exceptions

In the Accounts to use GlobalSum Methodology section, exceptions let you override how the Global Sum calculation is applied for specific situations. Exceptions are evaluated by scope, with more specific exceptions overriding more general ones.

Use exceptions only when an accoun needs to be calculated differently for a particular department or budget group than the default Global Sum setup.

  1. Double click Double Click to Insert New [Global Acct/Budget Group Acct/Dept Acct] Exceptions.

  2. Enter the number of rows to add and click OK.

  3. Enter the account number into the new row(s).

    NOTE: You can copy and paste account numbers.

  4. To save, right-click the 20 Budget GlobalSum tab and select Save > Save Data Only.

Fields and settings in the Accounts to use GlobalSum Methodology section include:

Option Description
Acct Identifies the account that will receive a value calculated by the Global Sum methodology.
Summary Group Column Selects which Account Summary Group column (AcctSumGroup1-AcctSumGroup4) to reference from the Revenue Accounts to be Summed section.
Lookup Column Tells the system which Account Summary Group column to use for the calculation.
Summary Group 1 Specifies the Summary Group whose total is used as the calculation base. Accounts assigned to this group are summed together.
Adjustment Factor - Summary Group 1 The percentage apoplied to the total of Summary Group 1.
Summary Group 2 (Optional) Specifies a second Summary Group to include in the calculation. Use Unused if not needed.
Adjustment Factor - Summary Group 2 The percentage applied to the total of Summary Group 2. Use a negative value to subract this group from the calculation.

Global Sum configuration includes the following tasks: