I am using the Report Designer Table to show a table of values taken from the database. I am using the header, detail, and summary sections of the table in the report designer. In the summary I am looking at the average values. The problem that I am coming across is some of the data points are NULL values which is perfectly normal, but I believe the reporting module is calculating them as zeros and skewing the average. The average calculation in the reporting module doesn’t match the averages calculated by MySql or Excel, which do not use the Null values in the average calculation (I believe). Any thoughts on this?
The table is showing the values that are null as N/A. My assumption was that those values would not be part of the average calculation.