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