Hi Kirk,

Try following.
Create 2 report variables:

rnTrueCount: IIF(FirstCase, 0, 1), 0, Sum, Reset at the end of the group
rnTimeTotal: Turnmin, 0,  Sum, Reset at the end of the group

In the group footer calculate average as rnTimeTotal/rnTrueCount

>I'm trying to create an average on a report group. The problem is that I can't have it average every record in the group, since the first value in the group is always for this field. I know which ones have the zero since there is a logical field called first record. I just can't figure out using the report variables how to exclude the zero's from the average.
>
>Sample Data and Desired Results
>

>case date room  Turnmin FirstCase
>02/03/04   1      0        .T.
>02/03/04   1     20        .F.
>02/03/04   1     10        .F.
>----Room Totals---------------------
>Case Cnt: 3   Avg Turn: 15
>

>Thanks for any help
>
>Kirk