We would like to be able to pull a list of all constituents who have given over a specific amount (this will change depending on who pulls the list) for the past 14 months. I looked at the header and got some ideas but am now stumped.
Detail Table: vs_contribution
Detail Col: sum(!.cont_amt)
If I leave it as is when I pull the criteria I am asked for a dollar amount and then it pulls anyone who has given cumulatively over that dollar amount ever. This is behavior that i would expect as i have entered nothing into the Where column. My problem is everything i try to enter into the where column pulls back errors.
Any help would be greatly appreciated.
Thanks
Margaret
When you say it errors out when you type anything into the where column, can you give an example of what you are typing in?
A good example of a dated element (assuming you are meaning query element here rather than flex header) would be the contribution last year giving (if you have it).
The where in that case is cont_dt > dateadd(yy,-1,getdate())
So if you wanted 14 months, you could theoretically use the above and do cont_dt > dateadd(mm, -14, getdate())