Hi,
Unfortunately, you aren't able to change the field type without data loss. So you'd have to either create a new field to capture this data in the type you'd like...or...remove values for this field on all records (which isn't ideal). You may be better suited to create a new field if you already have tons of record with data here.
Otherwise, you could write a fix script/background script to go through all records and clear it up to 2 decimals. Background script like this would help:
var gr = new GlideRecord('name_of_table');
gr.addQuery('name_of_float_field', '!=', '');
gr.query();
while (gr.next()) {
var float = gr.getValue('name_of_float_field');
var num = Number(float);
var newNum = num.toFixed(2);
gr.setValue('name_of_float_field', newNum);
gr.update();
}
So you'd want to supply your table name in appropriate spot and then your float field in the other 3 spots...this will check first to make sure it has a value now (so the script doesn't run unnecessarily) and then convert the current value from float to 2 decimal and then set the value back.
The above is an example, please take it from here. Consider referencing GlideRecord documentation if needed: https://developer.servicenow.com/dev.do#!/reference/api/orlando/server/no-namespace/c_GlideRecordSco...
Please mark reply as Helpful/Correct, if applicable. Thanks!
Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!
