Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Remove decimals from field type "currency"

NiKhil70
Kilo Guru

‎09-02-2020 07:38 AM

Hello ,

I have a requirement to remove the Decimal value related to Field "Budget Cost"

Projects - > Open any Project - > Under Financials - > We have field "Budget Cost" ( Field type is currency )

By Default the value is showing with Decimal , see the below screen shot for Reference.

How can i remove the decimal (.00) , it should show only "$8000" , 

No matter what the value is , it should show only without decimal 

find_real_file.png

Thanks , 

Nilesh .

Preview file
4 KB
0 Helpfuls
  • 1,304 Views
1 REPLY 1

Miguel Donayre
ServiceNow Employee
ServiceNow Employee

‎09-02-2020 08:00 AM

Hello HR,

OOTB on a currency field type there is no way to change it to no decimals. There is a system property that sets the decimals and it only have two options 2 or 4 decimals 

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/currency/task/cha...

There are some walk-around like this post - 

https://community.servicenow.com/community?id=community_question&sys_id=69bef2a5db58dbc01dcaf3231f96...

hope that helps!