Report Formatting with no Decimals

  • 2
  • Idea
  • Updated 4 years ago
  • Not Planned
  • (Edited)
It would be really great if there was a filter setting on reports to remove decimals. It's much easier to view reports when all decimals are removed and numbers are rounded. If it were made as a filter, each report could be customized to show decimals or not, and the selection would be reflected when reports are to be delivered recurringly.

There are already two partial solutions but neither are ideal. Both of which require custom formulas.
  • The first works if you do not have any grouped columns, as it converts numbers to text. Eg: Left(NumberToText(RoundHalfAwayFromZero(ActualBillableHours/1.68)), Len(NumberToText(RoundHalfAwayFromZero(ActualBillableHours/1.68)))-3)+"%"

  • The second works with grouped columns and rounds the numbers but still displays ".00" to all numbers. Eg: RoundHalfAwayFromZero(ActualBillableHours/1.68)/100
Photo of Neslin, Leonard

Neslin, Leonard

  • 5 Posts
  • 0 Reply Likes
  • frustrated.

Posted 4 years ago

  • 2
Photo of Aashnee Kamboj

Aashnee Kamboj

  • 1657 Posts
  • 116 Reply Likes
Hi Leonard,

Thank you for bringing up this idea. We will have this communicated to our team and will update you in case of any progress.

Aashnee Kamboj