Skip to main content
added 417 characters in body
Source Link

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 in interactions --> import, 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.

EDIT: I also noticed that when Marketing Cloud creates an automatic data extension for journeys using Salesforce data as entry source, with the currency field in the entry data, this works just fine and the separator is changed from comma to dot without the actual value being changed. But when trying to create the data extension with interactions --> import, the values get distorted.

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.

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 in interactions --> import, 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.

EDIT: I also noticed that when Marketing Cloud creates an automatic data extension for journeys using Salesforce data as entry source, with the currency field in the entry data, this works just fine and the separator is changed from comma to dot without the actual value being changed. But when trying to create the data extension with interactions --> import, the values get distorted.

edited tags
Link
Lukas Lunow
  • 22.2k
  • 4
  • 27
  • 59
Source Link

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.