Show Dollars in the correct format in Reports 2.0
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.
Already have an account? Login
Login to the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Thanks for the feedback. Other than displaying commas, what other data formatting options would be useful to you?
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.
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 🙂
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.
When we apply a COUNT on a Currency field, the result shows in currency format instead of a whole number format.