Spreading Values using Grid Spread

If your administrator has enabled Grid Spread, you can specify an amount or percentage to increase or decrease values across multiple dimensions on the grid, based on the existing values in the target cells.

When calculating the spread data, read-only and locked cells and cells having supporting detail are ignored. Data integrity is ensured because values can be spread only to cells to which you have access.

Note:

  • Grid spreading is supported in flex forms only in cases where the Period dimension is not flex enabled. If the Period dimension is in a column, then flex form should not be enabled on columns. Similarly, if the Period dimension is in a row, then flex form should not be enabled on rows.

  • If the Show invalid members for flex form option is enabled in a form where flex form is enabled only on rows, the rows contain any dimension other than Period, and the Period dimension in columns is not flex enabled, then grid spreading may work once, but does not work for subsequent spreading operations. While designing such forms, ensure that the Show invalid members for flex form check box, under Smart View Options in the Layout tab, is not selected so that grid spreading works in flex forms.

To spread values using Grid Spread:

  1. Open a form or an ad hoc grid.
  2. Position the cursor in the Subtotal or Total source cell whose value you want to spread to target cells.
  3. From the provider ribbon or provider ad hoc ribbon, select Adjust, and then select Grid Spread.
  4. From the drop-down menu, select one of these options:
    • Value to increase or decrease values by a specified amount
    • Percentage to increase or decrease values by a percentage
  5. Select Increase By or Decrease By and enter a value or percentage.
  6. In Spread Value, enter the actual spread value that you want.

    For example, if the Current Value is 100 and you want the spread value to be 125, enter 125 directly in Spread Value and do nothing with the Increase By/Decrease By options or text box in the previous step.

    Alternatively, you can enter 25 in Increase By, and 125 will be displayed in Spread Value.

    Note:

    Entering a value in Spread Value has no effect on the Increase By/Decrease By text box. But when you enter a value in Increase By/Decrease By, the spread value is reflected in the Spread Value text box.

  7. Select a spreading pattern:
    • Proportional Spread to spread the value proportionally, based on the existing values in the target cells (the default)
    • Evenly Split to spread the value evenly among the target cells
    • Fill to replace the value in all target cells

    Your administrator can add other spreading patterns.

  8. Click Spread. The specified value or percentage is spread across the target cells, replacing former values with new ones.
  9. To save the new values, submit the sheet.