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:
- The values in the Payroll % column is distributed to the child locations (DEPARTMENT1 and DEPARTMENT2).
- The values in the Payroll column is calculated for the child locations (DEPARTMENT1 and DEPARTMENT2).
- 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 |