We have Z* reports in SAP which when executed shows result in MS Excel. Earlier when we were using excel 2007 it was properly showing sum, count & average at the bottom of the page.
But SAP is not showing average, count & sum since we switched to excel 2016. It shows result if done externally without SAP.
The reason can be numbering structure different in SAP & Excel 2016 but I m not sure how to correct it.