9 Replies Latest reply on Dec 12, 2011 8:17 PM by Joe Mako

    when the donor splits their single gift among several causes, need to find the max total donation per donor per transaction (sum

    Craig Mullins

      i have a large donor base where donors can split their donation between several causes.

       

      for example a donor  may contribute $10,000, split between these causes:  $3,000 animals, $1,000 building, $6,000 unrestricted.

      our database returns each  donation per cause. not the $10,000. so i cannot find the max unallocated total donation, only the max from all the cause donations.

       

      i need to find for any time period the donor with max total donation, irrespective of the allocation to causes.

       

      i know there is a simple solution - any ideas?

      thanks