[cknepprath]

Quote:

Originally Posted by Melissa Siobhan

How do you know your results are way off? And how do you know that the number is not related to the reciept amount. If you know how it is off (who is missing or included who should not be) then it is much easier to troubleshoot.

Q 1: Summary Total gifts--1345 records

Q2: Summary Total gifts Receipt Amt--587 records

Q3: Merge: Q1 SUB Q2--759 records

I created a merge query and reviewed the summary of total receipt amount of gifts. (This is how I know that there is something not quite right here.) Records that are in Q1 and meet the criteria of Q2 are not in Q2. I "heard" something about soft credits not being "added" when using Summary Total Receipt amount criteria. BTW-I am using the exact same Gift Processing with Soft Credits and MG on all 3 queries.