Selecting from details of Group 1

[JCGSTL]

I have a report that groups all communications from individual companies. I want to select all companies that have, for example, contacted us in 2004 but not 2005 (so that I can filter out 2005-only contacts). I have tried using "If x then True" statements, but only manage to remove the individual communications, not the company concerned. Any help anywhere? Many thanks!

 

[lbass]

If you want to show all companies that had contacts prior to 2005, including those with contacts in both years, then group on {table.company} and then go to report->edit selection formula->GROUP and enter:

year(minimum({table.date},{table.company})) < 2005

If you specifically want to show companies with contacts prior to 2005, but with no contacts in 2005, then create a formula {@in2005}:

if year({table.date})>= 2005 then 1 else 0

Then go to report->edit selection formula->GROUP and enter:

sum({@in2005},{table.company}) = 0

-LB