>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
How about two variables?
one (i.e. SumMins) -> calculation SUM->Value to store iif(turnminutes>60,0,TurnMinutes)
other (i.e. CntMins) -> calculation SUM->Value to store iif(turnminutes>60,0,1)
Then just divide SumMins/CntMins
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.