Skip to Content
Former Member
Apr 25, 2014 at 07:12 PM

Getting Correct Average / Standard Deviation


I'm using Crystal Reports 2008.

I'm trying to average columns of numbers. I want to average them at the bottoms of the columns. The answers come through as strings, so I've created formula fields for each one in WhileReadingRecords - tonumber({field}) - in order to change each answer to a number, so they can be averaged.

However, the average for each column is not correct. Looking at it in Details, it's adding a 0.00 in the first line and does not include the last record.

How do I fix this so that the columns average out correctly?

The Standard Deviations are also not working, either using the Summary or using Running Totals.

Thanks again.