group. I have a Lookup Rollup Summary that counts the number of Events and Tasks the user has for the current month and the previous month and stores that information in four fields on the user record. These four fields are then used in two formula fields for the total number of activities the user has for the current and previous month.

It seems to work great. However, when I run a report of the user's activities and compare it to the values produced by the lookup rollup summary formula,148 match while 118 don't. Sometimes the number of activities is higher for DLRS, sometimes it is lower. The difference in values is anywhere from 1 to 46.

My relationship criteria for current month: ActivityDate=THIS_MONTH AND ActivityDate <= TODAY

My relationship criteria for previous month: ActivityDate=LAST_MONTH

Any idea on what could be causing DLRS to be lower or higher? Thank you in advance for your help!