Roll Up Summary Field
Declarative Lookup Rollup Summaries (DLRS)
Overview
DLRS is a tool designed to overcome limitations of Salesforce's native rollup summary fields. It enables:
- Rolling up child objects into parent objects
- Using filters to specify which child records to include in rollups
- Aggregating data from multiple fields into a single rollup field
Installation
To install DLRS:
- Navigate to the Salesforce AppExchange
- Search for "Declarative Lookup Rollup Summaries"
- Click the "Install" button
- Follow on-screen instructions to complete installation
Configuration
After installing DLRS, configure it by:
- Access Salesforce Setup > Objects and Fields
- Find the child object and click the "Rollup Summaries" tab
- Click "New"
- Enter a name and API name for the rollup summary
- Select the parent object in "Lookup Relationship"
- Choose the relationship field linking child to parent
- Add criteria to filter child records as needed
- In "Rollup Details," select the field to roll up and aggregation function
- Enter the API name for storing rollup data
- Set "Calculation Mode" to "Scheduled"
- Set "Sharing Mode" to "System"
- Save your configuration
Usage
To use DLRS:
- Navigate to the parent object
- Click the "Rollup Summaries" tab
- Select "Run Calculation"
- Choose the desired rollup summary
- Click "Run"
Data will aggregate from child objects into the specified parent field.
Scheduling
To enable automatic runs:
- Go to Setup > Objects and Fields
- Find the child object's "Rollup Summaries" tab
- Click "Manage Child Trigger" then "Install"
- Once Apex triggers are installed, click "Schedule"
- Select the rollup summary and desired schedule
- Save
DLRS will execute automatically per your specified schedule.
Troubleshooting
Verify the following if experiencing issues:
- Apex triggers have been installed
- Rollup summary configuration is correct
- Child records match relationship criteria
- Correct field is selected in "Rollup Details"
- Proper aggregation function is selected
- Field API name is entered correctly in "Rollup Details"
Contact Salesforce support if problems persist.