Example 3 locations are zero

Changing the payroll percent value for a parent when the payroll percent values for the parent and child locations are zero (0).

Suppose the initial values in the Sales, Payroll %, and Payroll columns are:

Location Sales Payroll Payroll %
STORE1 1000 0 0
DEPARTMENT1 600 0 0
DEPARTMENT2 400 0 0

If the value in the Payroll % column for STORE1 is changed to 10, then:

  1. The values in the Payroll % column is distributed to the child locations (DEPARTMENT1 and DEPARTMENT2).
  2. The values in the Payroll column is calculated for the child locations (DEPARTMENT1 and DEPARTMENT2).
  3. The values in the Payroll and Payroll % columns are recalculated for the parent location (STORE1).

The new values are:

Location Sales Payroll Payroll %
STORE1 1000 100 10
DEPARTMENT1 600 60 10
DEPARTMENT2 400 40 10