- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2024 10:50 PM
I want to show currency values as 500k or 500M in my dashboard. I used type as scorecard but it is showing the entire value which is not readable how can i show the value in 500k or 500M?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-11-2024 03:15 AM - edited ‎01-11-2024 03:16 AM
Hi @kiran kumar m1 ,
Ok then it will not work. According to documentation, no value formatting is available for currency field: https://docs.servicenow.com/bundle/vancouver-now-intelligence/page/use/reporting/reference/value-for...through the report designer.
I would instead suggest Performance Analytics, as this will be able to help with the value formatting.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2024 11:03 PM
Hi @kiran kumar m1 ,
Within the report single score, click the "set value formatting":
And enable "Enable abbreviation":
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2024 11:25 PM
For count Its working but when i tried for sum its saying "no formatting options are available for selected field type" is there any way that we can do it for sum?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2024 11:47 PM
Hi @kiran kumar m1 ,
What are you trying to summarize? As you can see below, I do not have any issues with sum and abbreviations in my PDI:
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-11-2024 03:00 AM
My field type is currency?