Total Rows should always total the lines above it, even if the lines above it are calculatued using a formula
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
Thanks for submitting your idea on Xero Product Ideas. We appreciate you taking time to let us know how we could improve Xero for you.
Your feedback will soon be reviewed by our Community team, and in the meantime this can begin to build support with votes from other community members.
If you're interested to see recent releases or get a pulse on what's coming soon see The Long and Short of it. 🙂