Skip to main content
puna
Helper ⭐️
August 16, 2019
Question

Rounding Up Integer/Currency to Higher Place Value in Reporting

  • August 16, 2019
  • 2 replies
  • 68 views
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
Gainsight Employee ⭐️
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
punaAuthor
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.