I've got a report that has an expression that finds the sum of a few fields (in the detail band) and at the end of the report I want the average of the vertical results (summary band). At present it gives me the average incorrectly as it includes 0 values in the total number of records. It should be the "sum of the records/total no. records (excluding 0.0 values)". How can I get the average excluding the records that contain 0.0 values?
Thanks
Max