Reporting Export - Excel total rows should add up formula column values
If I have a report and a column is a formula.
When I export that report to excel, the column has the underlying formula in each cell.
The column even has that formula in a cell that is in a total row. This is okay if the formula is a percentage, but never if the formula is an amount.
A total row with an amount should always be the total of the cells above it. Never any other formula.
Other column types (such as date), do not suffer this issue, they will correctly insert a formula that sums the cells above it, for a total.
Please fix the excel export so that it will correctly total the amount cells above it in the total row, even if the column is a formula column.
Sam Gray
shared this idea
Hi 👋 your idea is being looked into by our Community team. We'll be in touch soon to update you once your idea has been reviewed.
Did you know you can join our Xero Research panel to be involved in early testing and research? Find out more and sign up through our website 🙂
