Example 1: Reducing Values to Negative Numbers - Value Change
Suppose that:
- The value of the MASS_EDIT_BY_VALUE_REDUCTION_MODE registry parameter is ALWAYS_APPLY. This means that any value that would be reduced to a negative number because of a mass-edit by value is reduced to a negative number, according to the specified mass-edit by value option and the distribution rules.
- The 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 less than $50,000 have new values that are negative.
| 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 | -$20,000 |
| Jewelry department 4 | $45,000 | -$5,000 |
| Jewelry department 5 | $50,000 | 0 |
| Total of these jewelry departments | $250,000 | 0 |