Understanding the Recalculation Process
If a change triggers the recalculation process, the related fields are recalculated in a specific sequence to obtain the correct results. This table lists the sequence for each field that can trigger the recalculation process:
Field |
Explanation |
|---|---|
MTD-Gross Sales Amounts-This Year |
1 MTD-Gross Sales Amounts-Change 2 MTD-Per Square Foot (PSF) Amounts-This Year 3 MTD-PSF Amounts-Change 4 MTD-Percent Change 5 QTD-Gross Sales Amounts-This Year 6 QTD-Gross Sales Amounts-Change 7 QTD-PSF Amounts-This Year 8 QTD-PSF Amounts-Change 9 QTD-Percent Change 10 YTD-Gross Sales Amounts-This Year 11 YTD-Gross Sales Amounts-Change 12 YTD-PSF Amounts-This Year 13 YTD-PSF Amounts-Change 14 YTD-Percent Change 15 CYP (Current Year Projection)-Gross Sales Amounts-This Year 16 CYP-Gross Sales Amounts-Change 17 CYP-PSF Amounts-This Year 18 CYP-PSF Amounts-Change 19 CYP-Percent Change |
MTD-Gross Sales Amounts-Last Year |
1 MTD–Gross Sales Amounts–Change 2 MTD-PSF Amounts-Last Year 3 MTD-PSF Amounts-Change 4 MTD-Percent Change 5 QTD-Gross Sales Amounts-Last Year 6 QTD-Gross Sales Amounts-Change 7 QTD-PSF Amounts-Last Year 8 QTD-PSF Amounts-Change 9 QTD-Percent Change 10 YTD-Gross Sales Amounts-Last Year 11 YTD-Gross Sales Amounts-Change 12 YTD-PSF Amounts-Last Year 13 YTD-PSF Amounts-Change 14 YTD-Percent Change 15 CYP-Gross Sales Amounts-This Year 16 CYP-Gross Sales Amounts-Last Year 17 CYP-Gross Sales Amounts-Change 18 CYP-PSF Amounts-Last Year 19 CYP-PSF Amounts-Change 20 CYP-Percent Change |
MTD-PSF Amounts-This Year |
1 MTD-Gross Sales Amounts-This Year 2 MTD-Gross Sales Amounts-Change 3 MTD-PSF Amounts-This Year 4 MTD-PSF Amounts-Change 5 MTD-Percent Change 6 QTD-Gross Sales Amounts-This Year 7 QTD-Gross Sales Amounts-Change 8 QTD-PSF Amounts-This Year 9 QTD-PSF Amounts-Change 10 QTD-Percent Change 11 YTD-Gross Sales Amounts-This Year 12 YTD-Gross Sales Amounts-Change 13 YTD-PSF Amounts-This Year 14 YTD-PSF Amounts-Change 15 YTD-Percent Change 16 CYP-Gross Sales Amounts-This Year 17 CYP-Gross Sales Amounts-Change 18 CYP-PSF Amounts-This Year 19 CYP-PSF Amounts-Change 20 CYP-Percent Change |
MTD-PSF Amounts-Last Year |
1 MTD-Gross Sales Amounts-Last Year 2 MTD-Gross Sales Amounts-Change 3 MTD-PSF Amounts-Last Year 4 MTD-PSF Amounts-Change 5 MTD-Percent Change 6 QTD-Gross Sales Amounts-Last Year 7 QTD-Gross Sales Amounts-Change 8 QTD-PSF Amounts-Last Year 9 QTD-PSF Amounts-Change 10 QTD-Percent Change 11 YTD-Gross Sales Amounts-Last Year 12 YTD-Gross Sales Amounts-Change 13 YTD-PSF Amounts-Last Year 14 YTD-PSF Amounts-Change 15 YTD-Percent Change 16 CYP-Gross Sales Amounts-This Year 17 CYP-Gross Sales Amounts-Last Year 18 CYP-Gross Sales Amounts-Change 19 CYP-PSF Amounts-Last Year 20 CYP-PSF Amounts-Change 21 CYP-Percent Change |
QTD-Gross Sales Amounts-This Year |
1 QTD-Gross Sales Amounts-Change Amounts 2 QTD-PSF Amounts-This Year 3 QTD-PSF Amounts-Change 4 QTD-Percent Change 5 YTD-Gross Sales Amounts-This Year 6 YTD-Gross Sales Amounts-Change 7 YTD-PSF Amounts-This Year 8 YTD-PSF Amounts-Change 9 YTD-Percent Change 10 CYP-Gross Sales Amounts-This Year 11 CYP-Gross Sales Amounts-Change 12 CYP-PSF Amounts-This Year 13 CYP-PSF Amounts-Change 14 CYP-Percent Change |
QTD-Gross Sales Amounts-Last Year |
1 QTD-Gross Sales Amounts-Change 2 QTD-PSF Amounts-Last Year 3 QTD-PSF Amounts-Change 4 QTD-Percent Change 5 YTD-Gross Sales Amounts-Last Year 6 YTD-Gross Sales Amounts-Change 7 YTD-PSF Amounts-Last Year 8 YTD-PSF Amounts-Change 9 YTD-Percent Change 10 CYP-Gross Sales Amounts-This Year 11 CYP-Gross Sales Amounts-Last Year 12 CYP-Gross Sales Amounts-Change 13 CYP-PSF Amounts-Last Year 14 CYP-PSF Amounts-Change 15 CYP-Percent Change |
YTD-Gross Sales Amounts-This Year |
1 YTD-Gross Sales Amounts-Change 2 YTD-PSF Amounts-This Year 3 YTD-PSF Amounts-Change 4 YTD-Percent Change 5 CYP-Gross Sales Amounts-This Year 6 CYP-Gross Sales Amounts-Change 7 CYP-PSF Amounts-This Year 8 CYP-PSF Amounts-Change 9 CYP-Percent Change |
YTD-Gross Sales Amounts-Last Year |
1 YTD-Gross Sales Amounts-Change 2 YTD-PSF Amounts-Last Year 3 YTD-PSF Amounts-Change 4 YTD-Percent Change 5 CYP-Gross Sales Amounts-This Year 6 CYP-Gross Sales Amounts-Last Year 7 CYP-Gross Sales Amounts-Change 8 CYP-PSF Amounts-This Year 9 CYP-PSF Amounts-Change 10 CYP-Percent Change |
YTD-PSF Amounts-This Year |
1 YTD-Gross Sales Amounts-This Year 2 YTD-Gross Sales Amounts-Change 3 YTD-PSF Amounts-Change 4 YTD-Percent Change 5 CYP-Gross Sales Amounts-This Year 6 CYP-Gross Sales Amounts-Change 7 CYP-PSF Amounts-This Year 8 CYP-PSF Amounts-Change 9 CYP-Percent Change |
YTD-PSF Amounts-Last Year |
1 YTD-Gross Sales Amounts-Last Year 2 YTD-Gross Sales Amounts-Change 3 YTD-PSF Amounts-Change 4 YTD-Percent Change 5 CYP-Gross Sales Amounts-This Year 6 CYP-Gross Sales Amounts-Last Year 7 CYP-Gross Sales Amounts-Change 8 CYP-PSF Amounts-Last Year 9 CYP-PSF Amounts-Change 10 CYP-Percent Change |
CYP-Gross Sales Amounts-Last Year |
1 CYP-Gross Sales Amounts-This Year 2 CYP-Gross Sales Amounts-Change 3 CYP-PSF Amounts-Last Year 4 CYP-PSF Amounts-Change 5 CYP-Percent Change |
Square Footage This Year |
1 MTD-PSF Amounts-This Year 2 MTD-PSF Amounts-Change 3 QTD-PSF Amounts-This Year 4 QTD-PSF Amounts-Change 5 YTD-PSF Amounts-This Year 6 YTD-PSF Amounts-Change 7 CYP-PSF Amounts-This Year 8 CYP-PSF Amounts-Change |
Square Footage Last Year |
1 MTD-PSF Amounts-Last Year 2 MTD-PSF Amounts-Change 3 QTD-PSF Amounts-Last Year 4 QTD-PSF Amounts-Change 5 YTD-PSF Amounts-Last Year 6 YTD-PSF Amounts-Change 7 CYP-PSF Amounts-Last Year 8 CYP-PSF Amounts-Change |
MTD-Empty Months |
1 QTD-Empty Months 2 YTD-Empty Months |
QTD-Empty Months |
1 YTD-Empty Months |
MTD-Abs Chg SF (absolute change in square footage) |
1 QTD-Abs Chg SF 2 YTD-Abs Chg SF |
QTD-Abs Chg SF |
1 YTD-Abs Chg SF |
These fields are not affected by the recalculation process, nor does a change to them trigger the process:
Rolling 12 Months Sales
MTD-Net Change SF
Count Field
QTD-Net Change SF
PY Empty Mos (prior year empty months)
YTD-Empty Months
YTD-Net Change SF
YTD-Abs Chg SF