Question

Show Dollars in the correct format in Reports 2.0

  • 8 February 2016
  • 13 replies
  • 118 views

Userlevel 7
Badge +1
It is great to show the dollars in graphs but there are some graphs that just show the number and I am unable to format the number. For instance when I do a pie chart and say show values it will show me the percentages on the right in the legend and then the number values on the pie charts but it is hard to read "4355695483.98" compared to "$4,355,695,483.98". and it would be nice to be able to round to the closest dollar. 

13 replies

Userlevel 7
Badge
I received a similar request today. When we have a report that sums MRR, it leaves out the comma from $333000. 
Userlevel 7
Badge +1
Yes that is exactly it. It does this throughout different report types. Not sure why that is. 
Userlevel 5
Andrew/Lane,

Thanks for the feedback. Other than displaying commas, what other data formatting options would be useful to you?

Thanks,
Sumesh 
Userlevel 7
Badge
Hi Sumesh,

The comma is the only thing we've ran into so far. Other things would be things usually standard in writing. Automatically put commas in numbers. If it is currency, automatically put dollar signs in front. 
Userlevel 7
Badge +1
I would like the "$" also added to the appropriate spots. It would be great to be able to remove the "cents" and just show rounded to the nearest dollar. The same goes for just showing number and being able to have it round to the nearest dollar. Yes the comma is a big one too. 
Completely agree! We often display bar charts where one metric is numeric and the other is currency, so right now they both look like numbers. It would be great to differentiate the two!
Userlevel 4
Would like to set number formatting. In excel, we can set the format $3K instead of $3,352. Complete accuracy is noisy.
Userlevel 3
Is there any update on when we could have this option available within Gainsight?

Formatting numbers - having commas or dots in between digits
Choosing which kind of formatting should be applied (comma or dot, on whole Gainsight instance)

This is rudimentary stuff but helps immensely when dealing with large numbers that are completely unreadable without such formatting... unless you use your finger on the screen and count digits to figure out if you're dealing with millions or hundreds of millions 🙂
Echoing Alen's follow-up. I've had two other clients ask about similar formating.
Userlevel 5
In addition, it would be nice to be able to choose whether decimal places are shown or not.
To make sure it's clear, we need the formatting to apply when you hover over sections of the graphs as well. Also, on hover, there are some minor formatting issues (space after the colon for group by, space before the colon for the Total).
Userlevel 5
Badge
It's been a while since there was any activity on this post. Any update?

I would echo Daniel's use case especially (being able to label in $K or $M's). Showing the $ value in graphs is not clean and could be much more concise especially for presenting upstream.
Userlevel 6
Badge
Here's another minor related issue:

When we apply a COUNT on a Currency field, the result shows in currency format instead of a whole number format. 

Reply