Skip to main content
Question

Rounding Up Integer/Currency to Higher Place Value in Reporting

  • August 16, 2019
  • 2 replies
  • 47 views

puna
Forum|alt.badge.img+2
I may have missed it, but how does one abbreviate a value? Example: Rounding $58,014,494 to display 58M or $390,123 to 390K?

I have reports that show sums similar to these amounts and would like to display them in a cleaner fashion as the actual amounts make the report look very congested.

My thinking is it's not possible and that I'd have to create versions of the source data already in this format, but I really hope I'm wrong.

Thanks in advance!

2 replies

rakesh
Forum|alt.badge.img+2
  • Lets put your data to work!
  • August 21, 2019
Hi Puna,

Is this a problem in Charts or is this a problem in Tabular reports as well?

In charts, are you referring to data labels or axis labels?


puna
Forum|alt.badge.img+2
  • Author
  • Helper ⭐️
  • August 21, 2019
Hi Rakesh,

For my specific use case it's just for charts, but I can see this being a handy feature for tabular reporting too.