I have a report variable rm_Avg_Turn. The calculate option is set to average, and the Value to store is TurnMinutes. This all works great. The twist is that I want to print all records, but exclude from the average where the turnMinutes is greater than 60. I think in Value to store I could do an iif(turnminutes>60,0,TurnMinutes) but I also think that would ruin the average throwing a zero in.

Any ideas?

Thanks

Kirk