Loading
Salesforce now sends email only from verified domains. Read More
Set Up Trade Promotion Management
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Example: Referencing Other KPIs of Different Granularity

            You are here:

            1. Salesforce Help
            2. Docs
            3. Set up and Maintain Trade Promotion Management

            Example: Referencing Other KPIs of Different Granularity

            For some KPIs, you can reference the aggregated value of another KPI, for example, when calculating the percentage of volume of the current tactic that is contributed by the current product.

            Required Editions

            Available in: Lightning Experience

            Available in: Enterprise and Unlimited Editions where Consumer Goods Cloud is enabled
            Example
            Example Here are two KPIs:Sample KPI definitionSample KPI definition

            Based on this configuration, here’s how the tactic-level volume figures are calculated.

            KPIAggregation LevelTotalWeek 1Week 2Week 3
            Volume Promotion 1080 190 170 720
            Volume Tactic 1 750 100 50 600
            Volume Product 1 500 100 0 400
            Volume Product 2 250 Null 50 200
            Volume Tactic 2 330 90 120 120
            Volume Product 1 180 30 90 60
            Volume Product 3 150 60 30 60

            Here’s the calculated values of My Example KPI.

            KPIAggregation LevelTotalWeek 1Week 2Week 3
            My Example Promotion 600 200 200 200
            My Example Tactic 1 300 100 100 100
            My Example Product 1 166.67 (100/100) × 100 = 100.00 (0/50) × 100 = 0.00 (400/600) × 100 = 66.67
            My Example Product 2 133.33 0.00 (50/50) × 100 = 100.00 (200/600) × 100 = 33.33
            My Example Tactic 2 300 100 100 100
            My Example Product 1 158.33 (30/90) × 100 = 33.33 (90/120) × 100 = 75.00 (60/120) × 100 = 50.00
            My Example Product 3 141.67 (60/90) × 100 = 66.67 (30/120) × 100 = 25.00 (60/120) × 100 = 50.00
             
            Loading
            Salesforce Help | Article