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:

  1. The value in the Payroll column for DEPARTMENT1 is recalculated.
  2. The value in the Payroll column for STORE1 is aggregated.
  3. 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