Display a field value as round up/down in list view

Vinay Chaurasia
Tera Contributor

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. 

1 ACCEPTED SOLUTION

@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

 

VasantharajanN_0-1739874847977.png

 


Thanks & Regards,
Vasanth

View solution in original post

7 REPLIES 7

Vinay Chaurasia
Tera Contributor

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. 

Ankur Bawiskar
Tera Patron
Tera Patron

@Vinay Chaurasia 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

I also have same thought but will use in last if nothing will work. Thanks for you response.