---
schema_version: "1"
id: b4944aaa68a7185818e1bd110feae40c83854fba21bea3a9acc1e751ceb67bf6
title: "Example: Referencing Variables"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/ind/264-0-0/concept_referencing_variables_examples.md
canonical_url: https://help.salesforce.com/s/articleView?id=ind.concept_referencing_variables_examples.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 58cd9d412a151643ede25a9a5ed103aaab285043ce1ac5e34845900f0776a4c4
description: Depending on the scope of a KPI, you can reference a promotion or a tactic variable in a formula.
products:
  - Consumer Goods
release: "264"
---
# Example: Referencing Variables

Depending on the scope of a KPI, you can reference a promotion or a tactic variable in a formula.

### 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>

If the scope of a KPI is Promotion, Promotion Tactic, or Payment Tactic, the KPI can reference the Promotion object. Define fields of the Promotion object in the Promotion\_\_c.CalculationVariables fieldset. For example, if you have a Phase\_\_c field, then you can add the Promotion object as the input parameter in a formula.

![Promotion as Variable](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)

Promotion as Variable

```
{
    "name": "myExampleKPI",
    “scope”: “promotion”,
    "type": "calculated",
    "formula": "(MyKpi1, MyKpi2, Promotion) => { if Promotion.phase === 'Planning') return MyKpi1; else return MyKpi2}",
}
```

`(MyKpi1, MyKpi2, Promotion) => { if Promotion.phase === 'Planning')` returns `MyKpi1; else return MyKpi2}`

If the scope of a KPI is Promotion Tactic or Payment Tactic, you can use the Tactic object as the input parameter in a formula. Define fields of the Tactic object in the Tactic\_\_c.CalculationVariables fieldset.

![Tactic as Variable](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)

Tactic as Variable

```
{
    "name": "myReferencedKPI",
    "type": "read",
    "aggregation": {
        "rule": "sum"
    },
    "totalcalculation": {
        "rule": "sum"
    },
    ...
}, {
    "name": "myExampleKPI",
    “scope”: “promotiontactic”,
    "type": "calculated",
    "formula": "(myReferencedKPI, Tactic) => { return myReferencedKPI / Tactic.lift;}",
    "aggregation": {
        "rule": "sum"
    },
    "totalcalculation": {
        "rule": "sum"
    },
    ...
}
```

Here are the values for the tactic variable:

- amount: 3500
- lift: 7.5
- datefrom: 1493210282611

Here’s how the KPIs are calculated.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
            <colgroup>
              <col style="width:16.666666666666664%">
              <col style="width:16.666666666666664%">
              <col style="width:16.666666666666664%">
              <col style="width:16.666666666666664%">
              <col style="width:16.666666666666664%">
              <col style="width:16.666666666666664%">
            </colgroup>
            <thead class="slds-text-title_caps ">
              <tr class="">
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d70986e131">KPI</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d70986e134">Aggregation Level</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d70986e137">Total</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d70986e140">Period1</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d70986e143">Period2</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d70986e147">Period3</th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myReferencedKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Promotion</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">930</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">130</td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">140</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">660</td>

              </tr>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myReferencedKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Tactic 1</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">750</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">100</td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">50</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">600</td>

              </tr>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myReferencedKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Product 1</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">500</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">100</td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">0</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">400</td>

              </tr>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myReferencedKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Product 2</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">250</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">
                  <em>null</em>
                </td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">50</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">200</td>

              </tr>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myReferencedKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Tactic 2</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">330</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">90</td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">120</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">120</td>

              </tr>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myReferencedKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Product 1</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">180</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">30</td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">90</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">60</td>

              </tr>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myReferencedKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Product 3</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">150</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">60</td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">30</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">60</td>

              </tr>
              <tr class="">
                <td class="slds-cell-wrap" colspan="6" style="vertical-align:top;" headers="d70986e131 d70986e134 d70986e137 d70986e140 d70986e143 d70986e147 ">&nbsp;</td>

              </tr>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myExampleKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Promotion</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">7.5</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">1</td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">0.5</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">6</td>

              </tr>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myExampleKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Tactic 1</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">1</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">0.1333</td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">0.0666</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">0.8</td>

              </tr>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myExampleKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Product 1</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">0.6666</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">0.1333</td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">0</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">0.5333</td>

              </tr>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myExampleKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Product 2</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">0.3333</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">0</td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">0.0666</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">0.2666</td>

              </tr>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myExampleKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Tactic 2</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">1</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">0.2727</td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">0.3636</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">03636</td>

              </tr>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myExampleKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Product 1</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">0.5454</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">0.0909</td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">0.2727</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">0.1818</td>

              </tr>
              <tr class="">
                <td data-label="KPI" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e131 ">myExampleKPI</td>

                <td data-label="Aggregation Level" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e134 ">Product 3</td>

                <td data-label="Total" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e137 ">0.4545</td>

                <td data-label="Period1" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e140 ">0.1818</td>

                <td data-label="Period2" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e143 ">0.0909</td>

                <td data-label="Period3" class="slds-cell-wrap" style="vertical-align:top;" headers="d70986e147 ">0.1818</td>

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