Example 2 child location
Changing the payroll percent value for a child location.
Suppose the initial values in the Sales, Payroll %, and Payroll columns are:
| Location | Sales | Payroll | Payroll % |
|---|---|---|---|
| STORE1 | 1000 | 100 | 10 |
| DEPARTMENT1 | 600 | 60 | 10 |
| DEPARTMENT2 | 400 | 40 | 10 |
If the value in the Payroll % column for DEPARTMENT1 is changed to 0, then the following happens:
- The value in the Payroll column for DEPARTMENT1 is recalculated.
- The value in the Payroll column for STORE1 is aggregated.
- The value in the Payroll % column for STORE1 is recalculated. In this example, it is changed to 4%.
The new values are:
| Location | Sales | Payroll | Payroll % |
|---|---|---|---|
| STORE1 | 1000 | 40 | 4 |
| DEPARTMENT1 | 600 | 0 | 0 |
| DEPARTMENT2 | 400 | 40 | 10 |