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 |