Prevent ServiceNow from rounding up values when importing to currency field
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-26-2018 04:52 AM
Hi,
I need to import data from an excel speadsheet into 2 fields of the currency type.
A few of the values contain digits after the decimal point. However when i do the import, ServiceNow is rounding off the decimal points so that each new value in the field ends in .00.
How do I prevent this from happening?
E.g.
605.11 becomes 605.00
713.76 becomes 714.00
Any ideas?
Labels:
- Labels:
-
Cost Management
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2018 05:30 AM
Is this via a simple import or a transform?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2018 12:35 PM
Hi,
Please use below link
https://community.servicenow.com/community?id=community_question&sys_id=ecf683e5db1cdbc01dcaf3231f96191a
Mark this answer as correct and helpful.
Regards,
Manjusha Bangale
