Loading
Feature Degradation | Agentforce Voice Read More
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 Lifetime Value

            You are here:

            1. Salesforce Help
            2. Docs
            3. Automotive Cloud

            Calculated Insight: Vehicle Lifetime Value

            The Vehicle Lifetime Value calculated insight aggregates the lifetime revenue generated from all sales and service activities for a specific vehicle. The lifetime value of a vehicle includes the sales and service activities of 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 Vehicle_Sales_Detail__cio.VIN__c as VIN__c Extracts the vehicle identification number from the Vehicle Sales Detail calculated insight and assigns the value an alias VIN__c.
            SUM(Vehicle_Sales_Detail__cio.DealerSalesAmount__c + Vehicle_Sales_Detail__cio.DirectSalesAmount__c + Vehicle_Sales_Detail__cio.PartsTxnAmount__c + Vehicle_Sales_Detail__cio.RepairOrderAmount__c) as TotalAmount__c Calculates the sum of the dealer sales amount, direct sales amount, parts transaction amount, and repair order amount for each vehicle and assigns it an alias TotalAmount__c.
            FROM Vehicle_Sales_Detail__cio Specifies the source calculated insight that the total amount is derived from.
            GROUP BY VIN__c Groups the results by VIN__c, aggregating the revenue for each unique vehicle.
            HAVING SUM(Vehicle_Sales_Detail__cio.DealerSalesAmount__c + Vehicle_Sales_Detail__cio.DirectSalesAmount__c + Vehicle_Sales_Detail__cio.PartsTxnAmount__c + Vehicle_Sales_Detail__cio.RepairOrderAmount__c) > 0 Filters the grouped results to include only the vehicles where the total revenue is greater than 0.
             
            Loading
            Salesforce Help | Article