Decimal Precision on a Bar chart
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-07-2022 04:01 AM
Hi,
I have a Bar chart that uses SUM aggregation of a field. By default the Decimal Precision is to 2 decimal places
and it shows:
But when I change it to
It looks like this.
Surely the two 00 after the decimal point should not be there?
Any advice?
Many thanks,
Dan
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-07-2022 04:22 AM
According to ServiceNow, Decimal Precision will tell the accuracy of Decimal number. If you put it as 0, it means you don't want any Decimal values and it should append .00 only. So you need to put value between 0 to 4. 2 is default.
https://docs.servicenow.com/bundle/quebec-now-intelligence/page/use/reporting/reference/value-formatting-reports.html
Please mark this as correct answer if it resolved, or mark this helpful if this help you to reach towards solution.
Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-07-2022 04:26 AM
But adding 0 still gives you 2 decimal places even if they are 00. so it is not working correctly surely?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-07-2022 04:30 AM
I'm curious to see how it would work on a decimal field since those fields don't assume a format.
Currency field assumes a xxx.xx format, so in this case the precision is just rounding, not changing the way the field formats
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-07-2022 04:32 AM
I think you should try with more decimal places then 2 to see if it works good