We have a field on opportunity called "Active__c" which is defined as
NOT( IsClosed ) ||
(IsClosed && IsWon && Campaign_End_Date__c <= ADDMONTHS(TODAY(), 12) && Campaign_End_Date__c>TODAY())
We can't use a standard rollup summary field since active__c is defined in terms of a dynamic date
We use rollup helper to count the number of active opportunities, but it's currently taking an estimated 1 week and 6 days to run the job over about 200,000 accounts, which makes ROS basically useless.
Any suggestions?
Hello David,
You likely have a low record scope custom setting which is making Rollup Helper take longer to process through all the records of the object.
The record scope setting controls how many records are processed per apex job used to process your rollups.
Our support team can help optimize this setting for you so we can ensure your Rollups are running as fast as possible without hitting governor limits.
We would also recommend using real-time processing on all rollups so your results update automatically without having to do a manual run or schedule.
Please send an email to
support@passagetech.com after granting login access to Passage Technology and we will be happy to help!
