Extractions

Hi Michael, I built something for just this reason. Hopefully this works for you.
Description: Contributions (Number of)
Type: Number
Detail Tbl: vs_contribution_with_initiator
Deatil Col: count(distinct !.ref_no)
Category: contribution
Use for list: List Only

It will find people with a specific number of gifts. I would use >= 2 for your example. It should be able to work with all your other gift criteria as long as those are looking at the same table.

Hi Michael, I built something for just this reason. Hopefully this works for you.
Description: Contributions (Number of)
Type: Number
Detail Tbl: vs_contribution_with_initiator
Deatil Col: count(distinct !.ref_no)
Category: contribution
Use for list: List Only

It will find people with a specific number of gifts. I would use >= 2 for your example. It should be able to work with all your other gift criteria as long as those are looking at the same table.

Thank you!

Ann, does what system table should this code go into?

It goes in T_Keyword. That's where you can set up a bunch of custom criteria. You may have to get an IT person with permissions to put it in for you. Depending on how your org is set up. Here's the documentation: www.tessituranetwork.com/.../T_KEYWORD.htm

thank you!

Also this worked like a charm. Thank you!

I'm glad it worked!