Is there a formula that would show me how many event registrations we had 10-days prior to the start of an event?

Question

Here's what I have so far. The formula is valid but I still get records of registrations received the day of the event instead of just those who registered10-days prior and earlier.

IF(conference360__Attendee__c.conference360__Registration_DateTime__c:UNIQUE <= (conference360__Attendee__c.conference360__Event_Start_Date__c:UNIQUE - 10), 1, 0)

Steve Molis · Accepted Answer

PS. Personally, I would use a Formula(Number) like this

( conference360__Attendee__c.conference360__Event_Start_Date__c

-

conference360__Attendee__c.conference360__Registration_DateTime__c )

That way you can filter/bucket the Report over multiple Date Ranges, instead of being "locked in" to just 10+ Days

Scott Myers · Answer

Thanks  @Steve Molis https://trailblazers.salesforce.com/profileView?u=0053000000235ByAAI ! A formula(number) field worked perfectly in our sandbox. We'll move that to our production org shortly. It will help eliminate the extensive filter logic I had on that report (maxed out at 20 filters) and give us more flexibility. I definitely owe you a beer!

Is there a formula that would show me how many event registrations we had 10-days prior to the start of an event?

Formulas - Help, Tips and Tricks

Aide supplémentaire