Remove decimal points from Currency field

peter_repan
Tera Guru

‎01-21-2020 03:01 AM

Hi all,

is it possible to remove decimal places from Currency field?

Seems the "scale" dictionary attribute does not work on Currency field and the property https://docs.servicenow.com/bundle/london-platform-administration/page/administer/currency/task/chan... can only switching between 2 or 4 decimal places. 

Any experiences? 

Labels:
0 Helpfuls
  • 2,649 Views
2 REPLIES 2

Aniket Sawant
Mega Expert

‎01-21-2020 03:38 AM

Hi,

 

The decimal places are a combination of ‘Max length’ and the ‘scale’ attribute. If you want 4 decimal places, you’ll need a ‘Max length’ of 4 plus the default of 15, or 19. Your ‘scale’ attribute would be set to 4, to indicate the number of decimal places. 6 decimal places would require a max length of 21 and a scale attribute of 6, and so on.

For more information, you can refer to the following link.

https://www.servicenowguru.com/system-definition/controlling-decimal-field-places/

Please mark correct or helpful based on the impact.

Regards,

Aniket Sawant.

0 Helpfuls