I have a table with multiple dates and a value of 0+ for each date.  Some dates have 0.

I created a report and if I use Sum, everything works great.  Most days are in excess of 100.

However, if I change to average, the value in the report is always < 5.  At first, I thought it might be related to many dates having 0.  I created a filter and said all values of 0.01 + and that still didn't work.  In fact, I tried to even say only average values of 25 - 50 and the report still displayed ~5.

Any thoughts on why averages are not working or am I just missing something?

Thanks,

Chris