Skip to main content
andrew_cummins
Helper ⭐️
February 8, 2016
Question

Show Dollars in the correct format in Reports 2.0

  • February 8, 2016
  • 13 replies
  • 281 views
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

    lane_h
    Helper ⭐️
    February 12, 2016
    I received a similar request today. When we have a report that sums MRR, it leaves out the comma from $333000. 
    Director of CX and Scale Programs
    andrew_cummins
    Helper ⭐️
    February 12, 2016
    Yes that is exactly it. It does this throughout different report types. Not sure why that is. 
    sumesh
    Helper ⭐️⭐️
    February 15, 2016
    Andrew/Lane,

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

    Thanks,
    Sumesh 
    lane_h
    Helper ⭐️
    February 15, 2016
    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. 
    Director of CX and Scale Programs
    andrew_cummins
    Helper ⭐️
    February 16, 2016
    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. 
    jenny_bolden_0ab983
    Contributor ⭐️⭐️
    March 18, 2016
    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!
    daniel_oberes_b2e3e0
    Contributor ⭐️⭐️⭐️⭐️
    September 1, 2016
    Would like to set number formatting. In excel, we can set the format $3K instead of $3,352. Complete accuracy is noisy.
    alen_horvat
    Contributor ⭐️⭐️⭐️
    October 8, 2016
    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 🙂
    sean_ridley
    Contributor ⭐️
    October 18, 2016
    Echoing Alen's follow-up. I've had two other clients ask about similar formating.
    dave_wu_74b11e
    Gainsight Employee ⭐️
    Gainsight Employee ⭐️
    December 6, 2016
    In addition, it would be nice to be able to choose whether decimal places are shown or not.