To use currency values in a data transform, set a currency. This setting converts data with multiple currencies to a single value. For example, if your data includes GBP and USD and you set the currency to USD, the GBP values convert to USD. If you don't set a currency, the data remains unchanged.
To set the currency for your transform:
- In a batch data transform, click More actions, and then select Settings.
-
From the Select a currency dropdown menu, select a currency.
The setting saves automatically. Data preview reflects the new currency setting.