Loading
Automotive Cloud
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
            Calculated Insight: Vehicle Revenue From Parts Sales

            You are here:

            1. Salesforce Help
            2. Docs
            3. Automotive Cloud

            Calculated Insight: Vehicle Revenue From Parts Sales

            The Vehicle Revenue From Parts Sales calculated insight aggregates the lifetime revenue generated from the sale of parts and accessories for a specific vehicle. The vehicle revenue from parts sales considers the spare parts and accessories sold by the original equipment manufacturer and the dealerships.

            Required Editions

            Available in: Enterprise, Unlimited, and Developer Editions

            Here’s a breakdown of the logic.

            Expression Description
            SELECT SUM(ssot__LoyaltyTransactionJournal__dlm.ssot__TransactionAmount__c) AS PartsAmt__c Applies the SUM aggregation function to the Transaction Amount field in the Loyalty Transaction Journal object and assigns it an alias PartsAmt__c.
            ssot__Vehicle__dlm.ssot__VehicleIdentificationNumber__c AS VIN__c Extracts the Vehicle Identification Number field from the Vehicle object and assigns it an alias VIN__c.
            FROM ssot__LoyaltyTransactionJournal__dlm JOIN ssot__Vehicle__dlm ON (ssot__LoyaltyTransactionJournal__dlm.ssot__ExternalRecordId__c Joins the data in the Loyalty Transaction Journal and Vehicle objects by matching the External Record ID field on the Loyalty Transaction Journal to the ID field on the Vehicle object.
            GROUP BY VIN__c Groups the results by VIN__c, aggregating the parts sales for each unique vehicle.
             
            Loading
            Salesforce Help | Article