Having trouble with a query based on Average Gift amount

Leian Ireland 2 · October 2019

74ca65a0260088707bcfc093fcb0b290-huge-av

I am trying to to pull a list of donors who have made a donation from 01/10/2015 onwards AND their average gift amount is $5000 or more.

This is the criteria I have used in above picture. My issue is that I have someone whose last donation was in 2014 in the results and I cannot work out where I have gone wrong.

Hoping some one can help

Thanks in advance,

Lei-an

Aaron Rothberg · October 2019

Hi Leian-

Your Gift Date Range needs to be part of your summary criteria as opposed to separating it and then adding it to the summary criteria with an AND. Combine the two all under your summary criteria like this:

e2a8587a0dec0cc1c2dd442d2af144a0-huge-qu

Having trouble with a query based on Average Gift amount

Comments

Categories