- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-18-2025 12:11 AM
I have a table which has a decimal type field, in list view I want to show (without altering original data) that field as round up/down manner. Highly appreciated if anyone can help here.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-18-2025 02:35 AM
@Vinay Chaurasia - There is a small hack :-). Please refer the screenshot below
percentage is a column holds the actual value and the return type is Whole number which does the round up/down
Thanks & Regards,
Vasanth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-18-2025 01:45 AM
I am working for SPM module, in project table we have a field called Score which display data In decimal up to 2 digit (eg. 25.68). Now, customer is asking to show score value as round up or down. I tried a lot but unable to succeed in finding solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-18-2025 02:03 AM
not possible unless you create a custom field on that table which does the rounding off and stores data for your Decimal type field.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-18-2025 02:26 AM
I also have same thought but will use in last if nothing will work. Thanks for you response.