Additional Mass-Edit Options

When mass-editing data on the Worksheet, you can use the Change section of the Mass-Edit Criteria pop-up window to change value for multiple locations:

  • by a fixed percentage (% Change)
  • by adding or subtracting a value (Value Change)
  • by adding or subtracting a value that is then proportionately distributed to a set of locations in the hierarchy (Value Change Distributed)

For instructions on enabling this feature, see Setting Up Additional Mass-Edit Options.

The main difference between the Value Change and Value Change Distributed options in the in the additional mass-edit options is whether the change is applied in its entirety to each one of multiple locations, or whether it is distributed once among multiple locations:

  • The Value Change option applies this change to each location that meets the filter criteria. The changes are then distributed using the regular proportional distribution rules. For example, if the value of the change is 1000, then 1000 is added to each location.
  • The Value Change Distributed option distributes this change among all locations that meet the filter criteria. For example, if the value of the change is 1000 and there are 20 locations that match the filter criteria, then 1000 is distributed among those 20 locations.