Example 2: Reducing Values to Zero - Value Change

Suppose that:

  • The value of the MASS_EDIT_BY_VALUE_REDUCTION_MODE registry parameter is REDUCE_TO_ZERO. This means that any value that would be reduced to a negative number because of a mass-edit by value is instead reduced to zero.
  • The Value Change option is selected on the Mass-Edit Criteria pop-up window.

Suppose that you want to apply a decrease of $50,000 to an editable column on the Worksheet to the CORPORATE location, and you want to distribute this change to all jewelry departments. Based on the filter criteria, there are 5 departments, with the following values in each department:

Location Initial Value
Jewelry department 1 $50,000
Jewelry department 2 $75,000
Jewelry department 3 $30,000
Jewelry department 4 $45,000
Jewelry department 5 $50,000
Total of these jewelry departments $250,000

After the mass-edit, the departments have the following values. Any departments with initial values of $50,000 or less have new values of 0.

Location Initial Value Mass-Edited Hours (By Value Change)
Jewelry department 1 $50,000 0
Jewelry department 2 $75,000 $25,000
Jewelry department 3 $30,000 0
Jewelry department 4 $45,000 0
Jewelry department 5 $50,000 0
Total of these jewelry departments $250,000 $25,000