function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Collaborative eCollaborative e 

Create Roll-up Summary on Campaign Object

I want to create a roll-up summary field on the campaign object that totals opportunity values that meet certain criteria (date range of close date & Record Type).


I am at a loss. Any ideas? 


I simulated your case in my org and tested it, it works fine.






1)You have created master-detail relationship between Campaign(master) and Opportunity(detail).

2)You have a field something like 'Amount' in Opportunity object to be operated for summarising its values.

3) You have defined Record Types.


Define a roll-up summary field in Campaign say 'Total Opportunity Amount', follow the steps and for the situation that you want, use this criteria:


Opportunity Close date greater than 6/1/2009(in my case, I gave this) AND

Opportunity Close dateless than 6/30/2009 AND

Record Type equals rec_type1


Hope this may give you the idea to start going.