Budget Global Sum

Use the 20 Budget Global Sum (Global Sum) driver to calculate accounts as a percentage of other revenue or statistical accounts.

This driver uses totals from the Stat_Rev tab as the calculation base and applies the results to the appropriate Stat_Rev or Expense tab, depending on the account.

Global Sum is commonly used for items such as allowances, bad debt, or other adjustments that scale scale with revenue or volume. When the underlying Stat_Rev values change, the calculated results update automatically.

IMPORTANT: Do not modify any system-defined rows or delete columns without consulting administrator.

Configure settings

Before opening the driver, configure the required accounts in the ACCT dimension.

This driver uses accounts that are classified as GlobalSum in the ACCT dimension standard line (StdLine) column. You must complete this setup before using the driver.

  1. Go to Admin > Admin Task Panes > Budget Admin > View Dimension Tables.

  2. Double-click ACCT and complete the Open Table in Spreadsheet form.

  3. Find the account in the Account Number column.

  4. Double-click the StdLine field (for example, KHAStdLine) to view the calculation method values.

  5. Select GlobalSum.

  6. To save, right click the ACCT tab and select Save.

Configure driver settings.

  1. Go to Admin > Admin Task Panes > Budget Admin > Budget Assumptions and double click the desired driver set:
    • Access NY Budget Assumptions (next year's budget drivers)
    • Access CY Budget Assumptions (current year's budget drivers)
  2. To save any changes, right click the driver tab and select Save > Save Data Only.

Global Sum configuration includes the following tasks: