Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Cross Tab: Get Average of Non-Zero Records
Column1 Column2 Column3 Total Avg Bet 0 0.82 0.83 0.55 (Avg) No.of Games 3 1 5 9 (Sum) Shown above is how my report looks like, it shows the setup of my crosstab report. If you'll look into the Avg bet row (0.00...- jocom67
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Cross Tab: Get Average of Non-Zero Records
I'm using Crystal Reports v9 How can I get the average of non-zero records on a cross tab report? What's happening is that even the zero records are automatically included in the calculation of the cross tab average function. Thanks for the help.- jocom67
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 1 Formulas
