Rollup Helper Use Case Library

Total Closed Won Opportunity Sum

Problem

How do you calculate the sum of Closed Won Opportunities for each Account record?

Account, Opportunity, SUM, Pre-Built rollup

Total Closed Lost Opportunity Sum

Problem

How do you calculate the sum of Closed Lost Opportunities for each Account record?

Account, Opportunity, SUM, Pre-Built rollup

USE CASE: Calculate Total Value in Opportunities Pipeline by Account

Auto-deploy Total Amount in Pipeline rollup

Problem

How do you calculate the sum of non-closed Opportunities for each Account record?

Account, Opportunity, SUM, Pre-Built rollup

Number of Won Opportunities on an Account

Auto-deploy Number of Won Opportunities rollup

Problem

How do you calculate the number of won Opportunities for each Account record?

Account, COUNT, Opportunity, Pre-Built rollup

Number of Open Cases on an Account

Problem

How do you calculate the amount of open Cases for each Account record?

Account, Case, COUNT, Pre-Built rollup

USE CASE: Calculating the Number of Lost Opportunities for Accounts

Auto-deploy Number of Lost Opportunities rollup

Problem

How do you calculate the amount of lost Opportunities on each Account record?

Account, COUNT, Opportunity, Pre-Built rollup

Most Recent Opportunity Close Date

Auto-deploy Most Recent Opp Close Date rollup

Problem

How do you calculate the most recent close date of a closed child Opportunity for each parent Account record?

Account, MAX, Opportunity, Dates, Pre-Built rollup

Non-Profit Donations by Company

Problem

You want to be able to run a report to see what Accounts donated, and what its individual Employees donated, separately or together.

Account, Account Management, Contact, Opportunity, SUM, Industry: Nonprofit

Number of Email Tasks under a Contact

Problem

How do you calculate the amount of "Email" Tasks for each Contact record?

Account, Contact, COUNT, Task, Email, Pre-Built rollup

Number of Contacts without an Email Address

Auto-deploy Number of Contacts without Email rollup

Problem

How do you calculate the amount of Contacts without an email address assigned for each Account record?

Account, Contact, Email, Pre-Built rollup

Filtered by account

Subscribe

Tags

Problem

Problem

Problem

Problem

Problem

Problem

Problem

Problem

Problem

Problem