Skip to content
Sonia Chugh's Portfolio
My Portfolio
NPSP Project Overview
Data Design and Setup
Backend Configuration
Programming and UI
Add-on Configuration
Share
Explore

Customizable Rollup Fields

Unique to Salesforce NPSP, the org comes with 87 out of box roll up fields These essentially aggregate data from related child records to a parent record automatically. This is very helpful in quickly analyzing donor contributions and engagement.
The team at Florida Sight and Hearing Alliance would like to report on all donations both soft and hard credited. This will help in gaining an understanding on how much a donor has given whether funds were given directly or indirectly such as through Donor Advised Fund ( DAF) and third party platform like Facebook.
For this purpose, many customizable rollup fields were created.
Advantages:
Changing rollup default to Fiscal Year ( as opposed to Calendar Year used in the Standard Rollups)
Roll up from three years ago
Roll up soft credits

Here are the details for the settings and custom rollup fields created:

Expand or Collapse each section for your reference

Account Object

The following ‘Target’ fields were created on the Account Object:

First Account Soft Credit Amount (Currency)
First Account Soft Credit Date (Date)
First Contact Soft Credit Amount (Currency)
First Contact Soft Credit Date (Date)
First Hard Gift Amount (Currency)
Last Account Soft Credit Amount (Currency)
Last Account Soft Credit Date (Date)
Last Contact Soft Credit Amount (Currency)
Last Contact Soft Credit Date (Date)
Total Account Soft Credit Amount (Currency)
Total Account Soft Credits This FY (Currency)
Total Account Soft Credits Last FY (Currency)
Total Contact Soft Credit Amount (Currency)
Total Contact Soft Credits This FY (Currency)
Total Contact Soft Credits Last FY (Currency)

Customizable Rollups Configuration

In NPSP Settings,
Donations / Customizable Rollups has been enabled.
New Rollups created in ‘Configure Customizable Rollups’ that pointed to the Target fields. Refer to the table below to review all the fields created and their configuration. This will be a helpful reference for reviewing reports.
Table of Target Fields and Custom Rollups
Target Field
Customizable Roll up
Operation
Time Frame
Roll Up Type
Filter Group
Field to Roll Up
Date Field
Amount Field
First Account Soft Credit Amount
Account: First Account Soft Credit Amount
Opps: Won (SC)
Opportunity: Close Date
First Account Soft Credit Date
Account: First Account Soft Credit Date
Opps: Won (SC)
Opportunity: Close Date
First Contact Soft Credit Amount
Account: First Contact Soft Credit Amount
Opps: Won (SC)
Opportunity: Close Date
First Contact Soft Credit Date
Account: First Contact Soft Credit Date
Opps: Won (SC)
Opportunity: Close Date
First Hard Gift Amount
Account: First Hard Gift Amount
Opps: Won (SC)
Opportunity: Close Date
Last Account Soft Credit Amount
Account: Last Account Soft Credit Amount
Opps: Won (SC)
Opportunity: Close Date
Last Account Soft Credit Date
Account: Last Account Soft Credit Date
Opps: Won (SC)
Opportunity: Close Date
Last Contact Soft Credit Amount
Account: Last Contact Soft Credit Amount
Opps: Won (SC)
Opportunity: Close Date
Last Contact Soft Credit Date
Account: Last Contact Soft Credit Date
Opps: Won (SC)
Opportunity: Close Date
Total Account Soft Credit Amount
Account: Total Account Soft Credit Amount
Opps: Won (SC)
​
Total Account Soft Credits This FY
Account: Total Account Soft Credits This FY
Opps: Won (SC)
Opportunity: Close Date
Total Account Soft Credits Last FY
Account: Total Account Soft Credits Last FY
Opps: Won (SC)
Opportunity: Close Date
Total Contact Soft Credit Amount
Account: Total Contact Soft Credit Amount
Opps: Won (SC)
​
Total Contact Soft Credits This FY
Account: Total Contact Soft Credits This FY
Opps: Won (SC)
Opportunity: Close Date
Total Contact Soft Credits Last FY
Account: Total Contact Soft Credits Last FY
Opps: Won (SC)
Opportunity: Close Date
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.