Salesforce CPQ Summary Variables

In Salesforce CPQ, Summary Variables act as the "math engine" for your Quote Line Editor. They allow you to perform calculations across various records and use those results in Price Rules or Product Rules.

Here are 10 different scenarios for using Summary Variables:

1. Volume-Based Logic across Product Families: Calculate the total quantity of all products in the "Hardware" family to trigger a flat discount on "Software" line items.
2. Cross-Group Aggregation: On a quote with multiple Quote Line Groups, use a Summary Variable to find the total amount of the entire Quote to determine if the customer qualifies for a "Global Account Discount."
3. Tiered Discounting on Specific SKUs: Sum the quantity of a specific product (e.g., "User Licenses") to determine which Discount Schedule to apply via a Price Rule.
4. Enforcing Minimum Spend Requirements: Use a Summary Variable to total the Net Total of a "Professional Services" group. If the total is below $5,000, trigger a Product Rule that alerts the rep.
5. Average Unit Pricing: Create two Summary Variables—one for Total Net Total and one for Total Quantity. Use a Price Rule to divide them and populate a custom "Average Price Per Unit" field on the Quote.
6. Historical Asset Comparison: Create a Summary Variable with a Target Object of Asset. This allows you to count how many units of a product the customer already owns (on their Account) to determine pricing for their new purchase.
7. Renewal uplift Caps: During a Renewal, use a Summary Variable to sum the List Price of the previous Subscriptions. Use this to ensure the new renewal price doesn’t exceed a 5% increase over the original total.
8. Weight-Based Shipping Calculations: Sum a custom "Weight" field across all Quote Lines. Use the resulting Summary Variable in a Price Rule to calculate and inject a "Shipping Fee" line item.
9. Counting Unique Product Types: Use the Count function to see how many different "Security" products are on a quote. If the count is greater than 3, a Price Rule can automatically add a "Security Bundle Discount."
10. Composite Math for Multi-Year Deals: Use two Summary Variables to find the Quantity of products and the Subscription Term. Use a Price Rule with a Composite Operator to multiply them, helping calculate "Total Contract Months" across the whole quote.