Averages on a cross tab report

[SkyhiKeeper]

I have a cross tab report, on which I want the average of something, I have calculated the average in a formula however the crosstab has 10 lines in which there is only a culculated average in one, however the total average is determined on the average of the 10 lines how do I supress tha the other 9 lines that are 0 doe not get added into the average at the end ?

 

[Wallie12]

chek this site, he had an article on this recently:

http://www.kenhamady.com/