Aggregate Price in Pricing Procedures

Next in our Pricing Procedures series, after previously looking at the Price Adjustment Matrix element, we’re looking at the Aggregate Price element.

Pricing is the backbone of any revenue strategy, and Salesforce Revenue Cloud provides powerful tools to manage it effectively.

Among these tools is the Aggregate Price element in pricing procedures. This feature extends capabilities previously found in Salesforce CPQ, enabling users to roll up values both to the quote header and the bundle parent level.

This post explores the configuration and practical uses of Aggregate Price in Revenue Cloud.

What is Aggregate Price?

The Aggregate Price element allows you to calculate totals at different levels within your quote structure:

1. Bundle Totals: Roll up values to the parent product within a bundle.

2. Header Totals: Aggregate totals across specific products or categories to the quote header.

This is particularly useful when mimicking Salesforce CPQ features, such as calculating “Package Total,” or rolling up custom totals for specific product families or types.

Why Use Aggregate Price?

• Enhanced Reporting: Include rolled-up values in output documents and dashboards.

• Customizable Logic: Apply conditions to calculate totals for specific scenarios, such as products of a certain type or family.

• Improved Visibility: Expose critical data to users and processes for decision-making and automation.

Configuring Aggregate Price

To set up the Aggregate Price element, follow these steps:

1. Create and Map Custom Fields

• Define a custom field for the bundle total, such as Package Total. Map it to the Quote Line Item.

• Create another custom field for header totals, like Car TCV, and map it to the quote header.

2. Clone Your Pricing Procedure

• Avoid editing the active pricing procedure directly. Clone it to preserve the original configuration.

3. Add Aggregate Price Elements

• Open the cloned pricing procedure and deactivate it temporarily to make changes.

• Add an Aggregate Price element for each required rollup:

For Bundle Totals

• Rollup Setting: Enable the “Rollup Price” checkbox.

• Parent Assignment: Select the “Root Item Node” to aggregate values to the bundle parent.

• Formula: Use SUM(Total Line Amount) to calculate the total.

• Conditions: Apply conditions (if needed) to filter products included in the rollup.

For Header Totals

• Condition: Set a condition, such as Product Name = Model 3, to include only specific products.

• Formula: Use SUM(Total Line Amount) to aggregate the values.

4. Activate and Test the Configuration

• Reactivate the modified pricing procedure.

• Trigger a recalculation on a test quote by adjusting product quantities or adding new lines.

Practical Use Cases

1. Bundle-Level Rollups

Imagine you are quoting a bundle of software licenses. Using Aggregate Price, you can calculate and display the total price for the entire bundle, which includes parent and child products. This value can then be included in customer-facing documents or reports.

2. Header-Level Rollups

Suppose you are selling cars and need to calculate the total contract value (TCV) for a specific model (e.g., Model 3). Aggregate Price allows you to roll up the sum of all Model 3 quote lines to the header level for quick reference and reporting.

Tips and Best Practices

• Use Compatible Fields: Ensure your conditions are based on text, currency, or short text fields, as picklists are not supported.

• Limit Conditions: Aggregate Price elements support up to four conditions, so plan your logic accordingly.

• Test Thoroughly: Always test configurations in a sandbox or clone to avoid disruptions in live environments.

• Document Changes: Maintain clear documentation of your pricing procedure updates for future reference.

Learn More

Aggregate Price is just one of the many pricing procedure elements available in Salesforce Revenue Cloud. For additional pricing flexibility, explore features like the Price Adjustment Matrix. Learn how to use it for dynamic discounting in our related post: Dynamic Discounting with the Price Adjustment Matrix.

Ready to Master Salesforce Revenue Cloud?

If you’re looking to enhance your Revenue Cloud expertise, consider booking a consultation or exploring our tailored training programs.