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

OlaN
Giga Sage
Giga Sage

Hi,

I don't think this is doable without some DOM manipulation, which is to be avoided.

 

What's the use case for showing other numbers than the actual value in the list view in particular?

Vasantharajan N
Giga Sage
Giga Sage

@Vinay Chaurasia - You can use the function field using which you can do round off and display the column in list view and reports

 

 

VasantharajanN_1-1739871664416.png

 

More about function field, Please refer to the docs : https://www.servicenow.com/docs/bundle/yokohama-platform-administration/page/build/platform-function...

 


Thanks & Regards,
Vasanth

Hi Vasanth, Which function field operation you have used for Function Percentage filed as shown in above image. I can't find any operation to round off the filed in the link you provided.

@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