Adjusting Values

  To increase or decrease data values:

  1. Select the cells to adjust.

    You can adjust data for multiple cells simultaneously, if the writable cells are at the same level. For example, you can adjust the data for February and March simultaneously, but not for March and Q1. See Selecting Cell Ranges.

  2. Select Edit, then Adjust.

  3. Perform an action:

    • To increase or decrease values by a specified amount, from Adjust Data, select By Value, select Increase by or Decrease by, and enter the value to spread.

    • To increase or decrease values by a percentage, from Adjust Data, select By Percentage, select Increase by or Decrease by, and enter the percent value.

    You must enter a numeric value.

  4. Click Adjust Data.

    The values are displayed, with the number of decimal places that was set for the data form.

  5. Click Save.

You cannot adjust a data value if a member is read-only or null, that is, it is missing information.

Tip:

For information on how adjusting data may affect other cells, see How Spreading Data Works.