Change Field type from "Integer" to "Decimal"

[ramandeepgarg6]

Hi Friends.

Is it a good idea to change the "integer" type field to "decimal" type?
I tried doing it in our instance and it throw the below error while previewing the update set.

"Validate type change" business rule is already inactive for the instance. So what could have caused throwing this error?

Type change not allowed. Invalid type conversion for field 'Price' on table 'Draft Catalogue Import ...

Regards

Ramandeep

[Shashikant Yada · Accepted solution]

You need to create new field and give type as decimal.

[ramandeepgarg6]

Hi Shashank,

What do you think could have caused throwing that error?

Regards

Ramandeep

[Shashikant Yada]

I too was facing the same issue, but after doing community I found that

They are not compatible data types at the database level. You would end up with garbled information.

https://community.servicenow.com/community?id=community_question&sys_id=6dca53cedb7e578023f4a345ca961927

Thanks
Shashikant

Hit Helpful or Correct on the impact of response.