Totaling Groups of Specific Data in One Field??

[jwilson]

I've searched the available threads and couldn't find something like this. I would appreciate any help you can give(I'm just getting into calculations and scripts).

I have a number field titled "Transfer Times." I'm trying to create a report that will total the various times. Such as, how many 2 seconds for year 2003 and how many 3 seconds for year 2003, etc. An example of how the report should look is having a column for Transfer Time:

Transfer Time

1 sec

2 sec

3 sec

4 sec

5 sec

etc, etc

with a corresponding column entitled "Transfer Totals":

Transfer Totals

8 (total for # of times 1 second appears)

37 (total for # of times 2 seconds appears)

60 (total for # of times 3 seconds appears)

97 (total for # of times 4 seconds appears)

69 (total for # of times 5 seconds appears)

etc, etc

How do I get the Transfer Totals for each Transfer Time? I will, hopefully, later create averages of each specific transfer total to total number of transferred times.

Any help would be greatly appreciated!! My apologies if this was the incorrect thread to post in. This is my first time posting.

John

[LiveOak]

The easiest way is to create a summary field defined as "Count of" Transfer Times and report with a subsummary part. This type of part has the parameter "subsummary when sorted by...". In your case you want to sort by Transfer Times and place the subsummary field you created in the subsummary part. Because the Summary field doesn't add up all the Transfer Times, but gives you the count of the number of records wit that Transfer Time, you will get one line on your report for each different value of Transfer Time with the count of records with that time.

Just make sure your found set only contains 2003, then sort by Transfer Time. The subsummary report will only display properly in Preview mode or when printed (it doesn't calculate until then).

-bd

[jwilson]

Thanks a lot for the help. I'll give it a try.

John