Currency type field is rounding off its value

A document by KCS Integration on behalf of bac89b007c194479a7573c01f235e47b3ecc2bbb on May 8, 2018Last modified by Vishal Sharma on Jun 26, 2018
Version 3Show Document
  • View in full screen mode

Issue Description
"Currency" type fields are rounding off their value. For example, if you enter the value as 8092384905, Marketo is automatically rounding it to 809239000.


Issue Resolution
This is an expected behavior. TThe currency field type in MySQL is considered to be a Float field and MySQL will automatically round the values in our current database structure.


As a work around for this, change the field type to "string" . Since standard fields type cannot be changed, we suggest that you create a new custom field of type "String" to use instead of the standard field..



Is this article helpful ?