Mass-Editing by Value and Negative Numbers

Mass-editing by value means either adding or subtracting a value from the values of multiple locations. By default, specifying a value in the Change box and selecting either Value Change or Value Change Distributed from the By drop-down list on the Mass-Edit Criteria pop-up window adds the specified value to multiple locations. To subtract a value from multiple locations, specify a minus sign ( - ) before the number in the Change box.

When subtracting during a mass-edit, the new value for a location may be a negative number, depending on both:

  • the initial value of a location before the mass-edit
  • the distribution specified by selecting either the Value Change or Value Change Distributed option

You use the MASS_EDIT_BY_VALUE_REDUCTION_MODE registry parameter to determine how to handle a negative number calculated during a mass-edit. The following options are available:

  • ALWAYS_APPLY: (Default) Reduces the value to a negative value.
  • REDUCE_TO_ZERO: Reduces the value to zero (0) instead reducing it to a negative number.
  • NO_CHANGE: Does not change the value.

Note that this registry parameter setting applies to all editable columns edited during a mass-edit. Although there are some Worksheet columns where it may be illogical to have negative values, there is nothing in the system to prevent negative values in these columns if the registry parameter a default value of ALWAYS_APPLY.

See the Infor WFM Registry Parameter Reference Guide.

The following examples indicate how different values of the MASS_EDIT_BY_VALUE_REDUCTION_MODE registry parameter and the specific additional mass-edit option affect the mass-edited values.

Value of MASS_EDIT_BY_VALUE _REDUCTION_MODE Registry Parameter Mass-Edit Option Example
ALWAYS_APPLY Value Change Example 1: Reducing Values to Negative Numbers - Value Change
REDUCE_TO_ZERO Value Change Example 2: Reducing Values to Zero - Value Change
NO_CHANGE Value Change Example 3: Not Reducing Values at All - Value Change
ALWAYS_APPLY Value Change Distributed Example 4: Reducing Values to Negative Numbers - Value Change Distributed
REDUCE_TO_ZERO Value Change Distributed Example 5: Reducing Values to Zero - Value Change Distributed
NO_CHANGE Value Change Distributed Example 6: Not Reducing Values at All - Value Change Distributed