Counting Specific Data

[hoagieryder]

What is the best way to get a count of a particular instance in your data. I have a field called origination date. If the count of the fields that have an origination date greater than todays date is greater than 10, I want to suppress that group. Any ideas?

 

[lbass]

Create a formula {@futuredate} like this:

if {table.originatioindate} > currentdate then 1

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

sum({@futuredate},{table.group}) <= 10

This will display only those groups with 10 or fewer future dates.

Note that with group selection if you need to do calculations across groups, you must use running totals, since non-group selected records will contribute to the more usual inserted summaries.

-LB