How to fix decimal places in reporting currency fields.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-05-2023 06:29 AM
I have a currency type field in my table and I need to create a sum chart of these values. However, when I create the chart, 4 decimal places are added to my report and the value ends up being reduced. For example: original value (10,000.00) on my chart is 9,999.9982.
How can I adjust this in my charts to have a round value?
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-05-2023 07:08 AM
Hi,
the following should help:
In general, visit docs.servicenow.com and search using "Currency".
Maybe someone here has a quick answer on limiting the decimal places and rounding.