# Report Table Summary Averages **URL:** \ **Category:** Ignition\ **Created:** [December 5, 2011, 9:47pm UTC](https://forum.inductiveautomation.com/t/report-table-summary-averages/3697 "2011-12-05T21:47:55Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![jconnor34](https://avatars.discourse-cdn.com/v4/letter/j/c4cdca/32.png) [@jconnor34](https://forum.inductiveautomation.com/u/jconnor34)\ **Post date:** [December 5, 2011, 9:47pm UTC](https://forum.inductiveautomation.com/t/report-table-summary-averages/3697/1 "2011-12-05T21:47:55Z")
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. ---
**Author:** ![jconnor34](https://avatars.discourse-cdn.com/v4/letter/j/c4cdca/32.png) [@jconnor34](https://forum.inductiveautomation.com/u/jconnor34)\ **Post date:** [December 6, 2011, 5:40pm UTC](https://forum.inductiveautomation.com/t/report-table-summary-averages/3697/2 "2011-12-06T17:40:35Z")
I never got a reply on this so I ended up just writing a script to read each row in each column of a dataset and do an average that suppresses null data and then puts the correct averages into dynamic properties for the reportViewer to access. ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [December 9, 2011, 7:47pm UTC](https://forum.inductiveautomation.com/t/report-table-summary-averages/3697/3 "2011-12-09T19:47:39Z")
We’ll look into this. Good work-around though. ---
**Author:** ![Rutzzy](https://avatars.discourse-cdn.com/v4/letter/r/6de8d8/32.png) [@Rutzzy](https://forum.inductiveautomation.com/u/Rutzzy)\ **Post date:** [March 22, 2018, 9:11pm UTC](https://forum.inductiveautomation.com/t/report-table-summary-averages/3697/4 "2018-03-22T21:11:09Z")
Just wondering if a permanent solution has been implemented? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 22, 2018, 9:52pm UTC](https://forum.inductiveautomation.com/t/report-table-summary-averages/3697/5 "2018-03-22T21:52:34Z")
The [Simulation Aids](https://inductiveautomation.com/moduleshowcase/module/automation-professionals-llc-simulation-aids) module installs a set of system.aggregate.\* functions that ignore nulls as SQL expects, and makes those available in local scope for the [view()](https://www.automation-pros.com/simaids/doc/expression.view.html) Pseudo-SQL expression function. ---
**Author:** ![kaushik.shah](https://avatars.discourse-cdn.com/v4/letter/k/34f0e0/32.png) [@kaushik.shah](https://forum.inductiveautomation.com/u/kaushik.shah)\ **Post date:** [February 17, 2020, 2:22pm UTC](https://forum.inductiveautomation.com/t/report-table-summary-averages/3697/6 "2020-02-17T14:22:17Z")
Any update on this ? Ran into an issue where I have some columns with NULL which would not allow me to do summary calculations. ---
**Author:** ![Reyes](https://avatars.discourse-cdn.com/v4/letter/r/ccd318/32.png) [@Reyes](https://forum.inductiveautomation.com/u/Reyes)\ **Post date:** [September 5, 2023, 4:43pm UTC](https://forum.inductiveautomation.com/t/report-table-summary-averages/3697/7 "2023-09-05T16:43:14Z")
Any update on this? The average works, but it takes the columns with zeros. I created a nested query for each variable to remove the zeros, but it would be great if you added a function to customize the average calculation. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [September 5, 2023, 8:56pm UTC](https://forum.inductiveautomation.com/t/report-table-summary-averages/3697/8 "2023-09-05T20:56:55Z")
> [@Reyes](#): > > be great if you added Who is "you" in this suggestion?