---
schema_version: "1"
id: 3f339f6c46158ecb4ee38b7aedc55f71083980552ca8d09551af52fdb9034947
title: "Examples: Promotion Border Correction"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/ind/264-0-0/concept_promotion_border_correction_example1.md
canonical_url: https://help.salesforce.com/s/articleView?id=ind.concept_promotion_border_correction_example1.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: ae2aa24d6a3fe8cc5685fdcf9335b593c1569022f4913fba8c95f54691116641
description: Worked examples showing how promotion border correction calculates read values from the weekly and monthly Promotion Measure Result tables, including a year-offset scenario.
products:
  - Consumer Goods
release: "264"
---
# Examples: Promotion Border Correction

Worked examples showing how promotion border correction calculates read values from the weekly and monthly Promotion Measure Result tables, including a year-offset scenario.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition">
      <colgroup>
        <col>
      </colgroup>
      <tbody>
        <tr class="">
          <td class="slds-cell-wrap" style="vertical-align:top;">
            <p>Available in: Lightning Experience</p>
            <p style="margin-bottom:0;">Available in: <strong>Enterprise</strong> and <strong>Unlimited</strong> Editions where Consumer Goods
              Cloud is enabled</p>
          </td>

        </tr>
      </tbody>
    </table>

The system reads values from the Promotion Measure Result JSON table if a flexible writeback structure is used.

The writeback structure stores weekly, monthly, and custom values for each product ID in JSON tables based on account plan, promotion, or tactic. To use the writeback structure, you must activate promotion border correction.

![Reading Values from the Weekly Promotion Measure Result Table](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-consumer_goods_trade_promo-264-0-0-production-enus/169b0c8b-175d-4639-bf96-610b16824687/images/icon_example.png)

Reading Values from the Weekly Promotion Measure Result Table

Here’s the data for Promotion ABC for a week.

![Sample data](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-consumer_goods_trade_promo-264-0-0-production-enus/169b0c8b-175d-4639-bf96-610b16824687/consumer_goods_trade_promo/images/calculation_kpi_values_example1.png)

The Promotion time frame spans from Monday through Friday, and the Read time frame spans from Wednesday through Sunday. Based on the overlapping time frames and the writeback value, here’s how the correction factor is calculated.

Read value = Writeback value × (Value of the weekday share for which both time frames are valid) / (Value of the weekday share for which the Promotion time frame is valid) = 100 × (Value of the weekday share from Wednesday to Friday) / (Value of the weekday share from Monday to Friday) = 100 × (10 + 20) / (10 + 20 + 10 + 20) = 50

Based on the overlapping of the time frames, the week has three subperiods:

- Subperiod 1 = Monday through Tuesday
- Subperiod 2 = Wednesday through Friday
- Subperiod 3 = Saturday through Sunday

Here’s how the value of each subperiod is calculated.

- Because subperiod 1 is completely outside the Read time frame, the subperiod is empty.
- Value of subperiod 2 = Read value × (Value of the weekday share of subperiod 2) / (Value of the weekday share of the Read time frame) = 50 × (10 + 20) / (10 + 20 + 20 + 20) = 21.43.
- Value of subperiod 3 = Read value × (Value of the weekday share of subperiod 3) / (Value of the weekday share of the Read timeframe) = 50 × (20 + 20) / (10 + 20 + 20 + 20) = 28.57.

The total distribution value is the sum of values of all the subperiods: 0 + 21.43 + 28.57 = 50.

![Reading Values from the Monthly Promotion Measure Result Table](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-consumer_goods_trade_promo-264-0-0-production-enus/169b0c8b-175d-4639-bf96-610b16824687/images/icon_example.png)

Reading Values from the Monthly Promotion Measure Result Table

Here’s the data for Promotion PQR in February.

![Sample data](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-consumer_goods_trade_promo-264-0-0-production-enus/169b0c8b-175d-4639-bf96-610b16824687/consumer_goods_trade_promo/images/calculation_kpi_values_example2.png)

For February, the Read time frame spans from Feb 18–29, and the child time frame spans from Feb 19–23. Based on the child time frame and the writeback value, here’s how the correction factor is calculated.

Read value = Writeback value × (Value of the weekday share for which both time frames are valid) / (Value of the weekday share for which the promotion time frame is valid) = 100 × (10 + 20 + 20 + 20) / (10 + 20 + 20 + 20) = 100

Based on the Read time frame and condition values (C1, C2), the month has three subperiods.

- Subperiod 1 = Feb 01–17
- Subperiod 2 = Feb 18–21
- Subperiod 3 = Feb 22–29

Here’s how the value of each subperiod is calculated.

- Because subperiod 1 is completely outside the Read time frame, the subperiod is empty.
- Value of subperiod 2 = Read value × (Value of the weekday share of subperiod 2) / (Value of the weekday share of the Read time frame) = 100 × (20 + 10 + 20) / (20 + 10 + 20 + 20 + 20 + 10 + 20 + 10 + 20 + 20) = 29.41.
- Value of subperiod 3 = Read value × (Value of the weekday share of subperiod 3) / (Value of the weekday share of the Read time frame) = 100 × (20 + 20 + 10 + 20 + 10 + 20 + 20) / (20 + 10 + 20 + 20 + 20 + 10 + 20 + 10 + 20 + 20) = 70.59.

The total distribution value is the sum of values of all the subperiods: 0 + 29.41 + 70.59 = 100.

![Reading Values from the Weekly Promotion Measure Result Table When Year Offset =
1](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-consumer_goods_trade_promo-264-0-0-production-enus/169b0c8b-175d-4639-bf96-610b16824687/images/icon_example.png)

Reading Values from the Weekly Promotion Measure Result Table When Year Offset = 1

Here’s the data for Promotion ABC for a week.

![Sample data](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-consumer_goods_trade_promo-264-0-0-production-enus/169b0c8b-175d-4639-bf96-610b16824687/consumer_goods_trade_promo/images/calculation_kpi_values_example3.png)

For the given week, the promotion time frame spans from February 17–21, 2020. The Read time frame with year offset = 1 spans from Feb 18, 2021 to Feb 21, 2021. Based on the overlapping time frames and the writeback value, here’s how the correction factor is calculated.

Read value = Writeback value × (Value of the weekday share for which both time frames are valid) / (Value of the weekday share for which the Promotion time frame is valid) = 100 × (Value of the weekday share from Tuesday to Friday) / (Value of the weekday share from Monday to Friday) = 100 × (20 + 10 + 20 + 0) / (10 + 20 +10 + 20 + 0) = 83.33

Based on the overlapping time frames, the week has three subperiods.

- Subperiod 1 = Monday through Wednesday
- Subperiod 2 = Thursday through Friday
- Subperiod 3 = Saturday through Sunday

Here’s how the value of each subperiod is calculated.

- Because subperiod 1 is completely outside the Read time frame, the subperiod is empty.
- Value of subperiod 2 = Read value × (Value of the weekday share of subperiod 2) / (Value of the weekday share of the Read time frame) = 83.33 × (20 + 0) / (20 + 0 + 20 + 20) = 27.78.
- The value of subperiod 3 = 55.56.

The total distribution value is the sum of values of all the subperiods: 0 + 27.78 + 55.56 = 83.33.

The system applies promotion border correction when reading values with a year offset from the Monthly Promotion Measure Result table.