Hi Tony,

Actually, after I posted my solution, I realized I wrote a custom formatter for percentages that was inserting the single space. Can't remember why exactly as it seemed to perform the same way when I took the single space out. Maybe it was a typo on my part.

I would think that if the cell value is null or, when the white space is trimmed, equals empty string, then the cell's value should not count towards the average.

At the very least, I think that null and empty string should not count – I think you could make a case either way about the trimming of whitespace.

Thanks!

– Joe

Just found another problem with the averaging function. Same 30 rows, different column containing percentages. 7 of the 30 cells in this column are blank (see screenshot below where “v” is ” ” – presumably not truly blank so the browser styles the cell correctly). Because of the ” ” is not a number and fails parseFloat(), JQGrid calculates the average as “NaN”.