Skip to main content
2 of 3
edited tags
Lukas Lunow
  • 22.2k
  • 4
  • 27
  • 59

Decimal separator comma not working in currency field in Marketing Cloud

I have a currency field (16,2) in Salesforce, with € as currency and comma as the decimal separator. When I try to import Salesforce reports and their data to Marketing Cloud, the data in the currency field is distorted, because the decimal separator in Marketing Cloud in the currency field is a dot. This means that values are completely wrong, e.g. 12,00 € in Salesforce would be 1200.00 € in Marketing Cloud. How can I fix this? I have not found a way to change the decimal separator in Marketing Cloud to comma, and I don't want to change it to a dot in Salesforce, because we operate in a country where the separator is always a comma, so this would mix all of our reports.