#Roll-up Summary Fields1 discutindo

Hi @Margaret Carr,

Try this -

IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 10000, 
   IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pHjR&oid=00D61000000HOeU&lastMod=1729020447000", "Producer Circle"), 
   IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 5000, 
      IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pHeb&oid=00D61000000HOeU&lastMod=1729020377000", "Celebrity Circle"), 
      IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 2500, 
         IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pBvm&oid=00D61000000HOeU&lastMod=1729020291000", "Director Circle"), 
         IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 1000, 
            IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pHOT&oid=00D61000000HOeU&lastMod=1729020215000", "Musical Director Circle"), 
            IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 500, 
               IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pHBa&oid=00D61000000HOeU&lastMod=1729020135000", "Designer Circle"), 
               IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 250, 
                  IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pGnN&oid=00D61000000HOeU&lastMod=1729019901000", "Choreographer Circle"), 
                  IF(Account.PatronDonate__AmountDonatedInLastNDays__c >= 100, 
                     IMAGE("https://mainestatemusictheatre.my.salesforce.com/servlet/servlet.ImageServer?id=015Qj000003pGVd&oid=00D61000000HOeU&lastMod=1729019771000", "Ensemble Circle"), 
                     "")
               )
            )
         )
      )
   )
)

The MVP specific is simply that I'm an MVP and the MVP Collaboration Space is a channel I've been active in, so it was one that I have always posted by blog post notifications to. (Though that channel gets a lot less traffic now that there is an official MVP Slack.) I tag groups not based on topic, but based on membership (ie. ones I am a member of and regularly follow). 

The topic on this one was

, which I think was the right one. 

You're not alone in it being hard to filter content on the TBC. There's a lot here. My strategy is to pick a couple of channels that I actively watch. I usually set those to notifications for Every Post. Or I go in every so often and just skim down. (I used to read the weekly digests for a bunch of others, but for a while now I've just been ignoring the weekly digests because they're too overwhelming.) It's still overwhelming.

While you could technically use DPE for this, it's not really the best approach... There are two I have used in the past that have worked for me:

1. Flow - you could create a scheduled flow to run every evening to calculate the new totals for any donor who has given in the previous 24 hours. Pull all of their donations since the start of the year and sum them to the fields you've created

2. Use DLRS - this is a 3rd party tool (free) that a lot of people (non profits and beyond) use for exactly this purpose. Declarative Lookup Roll-up Summary allows you to configure a process that it generates apex code for (since apex can be more efficient for large data manipulation than flow). A few clicks and you're done (you don't have to know how to code apex for this at all!)

Hi @Marcela Caso ,

Improve the financial accuracy of your Salesforce data today with Rollup Helper

With Rollup Helper, you can rollup any currency type on child records and they will each be translated into your organization's default currency before aggregation begins. From there, we will rollup the aggregate figure and translate it into your target object's default currency type. For example, let's say you have a customer who is located in Canada, Rollup Helper will convert the source records currency type to CAD and also display the organizations default currency amount next to the CAD amount in the target field.

We also support Advanced Currency Management. This is a HUGE feature because in the past, if you needed multiple currencies setup in Salesforce and wanted to keep the exchange rates dynamic, you could not enable this functionality without comprising Salesforce's native rollup functionality. This meant choosing between having rollups or having accurate financial data. We want you to have the best of both worlds, so with Rollup Helper, you can now safely enable Advanced Currency Management.

https://www.passagetechnology.com/acm

https://trailhead.salesforce.com/trailblazer-community/feed/0D53000002Dl79cCAB

@Saf Burki I have quickly recreated this, and it looks Ok.

Hello Saf,

When creating a Rollup filter on the page in the top right corner next to the limit setting you'll see there's an additional field, the text reads:

Limit this rollup to _____ child records per parent.

Skips _____ child records per parent.

 These settings allow you to return only a limited number of child records from those that past the filter criteria defined in step 3.  This can be used for things like returning the 5 most recent task names, 3 largest opportunities, first contact created for the account   

The Skips field can be used if you want to know something like the 2nd newest created record The sort order determines if you are selecting the oldest or newest records ASC puts the newest records at the top of the list. Limit 2 will pull the 2 newest records, and if you only want the 2nd newest record you would set Skips 1 child records per parent.