Average Formula excluding zero records
Posted on 2004-09-30
I'm new to Crystal Reports 9 and am trying to create a report that summarizes the results of our customer survey. Column one is the score for each record (0 - 5). I need to calculate the average ecluding the records containing a zero. for example i have 391 records of which 5 contain zero. The total sum of the entries in the column is 1802. If I exclude the 5 records containing a zero the average for the column should be 4.67.
I tried the formulas located in your answer section but they bring back an average of 4.61. I'm not sure what I am doing wrong and being new I can spend forever trying to figure it out - can you help? Thank you.