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 |