I have a table that list EMS unit responses.

Each response is referenced by Incident number and each unit responding is referenced by run number, each record has response time for responding unit. Example

Incident#   Run#  Unit# Address               RespTime

123                22      A1         1212 12^th              5.50

123                23      F2         1212 12^th              2.50 

I want to be able to reference the shortest response time for each incident to do calculations, such as overall avg response time.

I have grouped records by Incident number and have the min response time displayed in the group header but I am unable to do calculation based off of that field. See example below.

48,204 3.45

Date                 Inc#                  Run#                TOC                 TOS                 RespTime         Unit

2010-11-30        48,204             46,316              00:04:11            00:11:03            6.87                  52        

2010-11-30        48,204             46,317              00:04:35            00:08:02            3.45                 Fx4

Thanks for your assistance

I created a formula field “IncRespTime”

if {@RespTime}=Minimum ({@RespTime}, {Trips.IncidentID})then Minimum ({@RespTime}, {Trips.IncidentID})else 0

I placed this field in the report, I set field to suppress if 0 which shows the correct response time for the incident.

Date                        Inc#             Run#           TOC                TOS                    RespTime      Unit         IncRespTime

2010-04-13     26,009    14,082    05:27:41   05:37:47     10.10          45

2010-04-13     26,009    14,083    05:27:56   05:35:44      7.80           Fx1          7.80

But when I try to get the average of that field I get an error that I cannot summarize that field.

I hope this makes since