Splashing values from consolidated accounts

Splashing refers to the distribution of values in a workbook according to a variety of rules. You can splash values from consolidated accounts to base accounts.

The Splasher option is available on the Data Entry tab.

You can use the Splasher option only if all values under the selected account have the same global sign, or at least one base account has some value available.

  1. Click a consolidated cell and select Splasher. You can select a consolidated cell in the year column or a month column.
  2. Select one of these splashing methods and specify the value:
    Option Description
    Overwrite value Replace the current value with a value that you specify.
    Increase or decrease value Increase or decrease the current value by an amount that you specify.
    Increase or decrease % value Increase or decrease the current value by a percentage that you specify.
    Note: 

    All three options are available only when at least one base account have some values available.

    In other cases, only the overwrite value option is available.

    Values are splashed equally when all accounts have the same global sign, at least one base account has some values available, and aggregation from all base accounts results in zero.

  3. Click OK.