Reporting - Excel export change behaviour of total row value where column formula used
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 Sam, really appreciate you coming into our Xero Support team about this so we could get a closer look into the behaviour that you've mentioned.
I've re-opened this and slightly adjusted the title of your idea now that we have a clearer picture. Just to highlight for others coming across - currently when you export a report to Excel the formula in the column takes precedence over the total calculation.
There are no plans for changing this at this time, however we'd like to get a wider sense of thew interest through the idea here so that our product teams can consider this in future planning. Thank you
