Exporting the report to Excel or Google Sheets and averaging the column returns a different result than Zoho did using the  aggregate records average function and displaying the results in a html page.

I believe it might have to do with blank fields within Zoho's averaging range that might not be ignored.

So what can be done to fix this or increase the accuracy of the returned results?

Additionally is there anyway to limit the amount of decimal places that are shown?

Thank you

Update: I just exported a report and averaged a (with no blank cells) column in a spreadsheet and the average that was returned did not match Zoho's average.