Custom report - Add formula rows for % percentages (e.g Gross/Net profit)
Custom Reports: It would be great to be able to add a formula row in the custom reports that can display as a percentage. For example GP% and NP%
Or just have the ability to add a GP% and NP% row.
Thanks for your input and letting us know how useful being able to show formula rows as %'s would be when reporting from Xero.
This is something our team have plans to pick up work for soon and for now we'll move to Under review, I'll return to share as this moves along 😊
-
James Love commented
Can't believe this is still not available. It would be such a basic fix and these types of margin outputs are used every day
-
Jonathan Maehler commented
Guys this is needed asap
-
Lisa Ho commented
Would definitely be useful as I check this after every month for clients so would save time as would have also have a comparison figures
-
Mari-Louise Stoltz commented
I use this on every report currently for a group of clients so having this in xero would save a lot of time.
-
Chris Curlett commented
This is a great idea and would be a real help
-
Innes Chalmers commented
Now April 2024 and still not clear that I can show a row of %s in a custom report in % format.
Why is Xero finding this difficult?
-
Steve Rose commented
The ability to show a % symbol would be very helpful. I have to export a report to Excel to do this.
-
Dale Pinn commented
Since 2022 and still no percentage sign?
-
Grace Vardy commented
It would be so much better visually to be a %!
-
Angela Peden commented
Percentages are pretty essential for meaningful reporting
-
Tania Evans commented
I really just want to see the % sign, rather than the result as a decimal - this would be so useful
-
Gill Cook commented
It would be really useful
-
Clair Chapman commented
Yes please to this, I can't believe that this isn't a function. Assumed that something so fundamental would be there as a standard option.
-
Grant Beck commented
I vote for this as well. Even with the workaround, the Total column does not properly calculate these values so that would be need to be addressed.
-
Chris Thomas commented
Another vote for the percentage formula in a custom report please Xero.
-
Charisse Russell commented
Okay so I'm here looking to see if this function has been enabled + it appears that it hasn't yet. YES to adding this as a basic function from a management reporting POV.
-
pete hill commented
With all the technology I can't for the life of me see why this very basic function is so impossible
-
Caitlin Ottley commented
This is a basic function we usually include in both management and annual financial statements, please action this soon
-
Ahmad Qayyum commented
Yes this is a basic ratio that businesses need GP% and NP% etc.
-
Elmar Ezra Tongol commented
It would be good if Xero will add a function (shown as a percentage) when doing a formula in a row.