Splashing values to consolidated accounts

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

The Splasher option is available on the Data Entry tab. The Splasher option in Application Studio is not supported.

If the Zero Suppression check box is selected when choosing the accounts to display, all child elements are affected when splashing even if the accounts are not displayed.

  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.
  3. Click OK.