Salesforce Currency

If you have convertCurrency function enabled in your Salesforce organization, HockeyStack by default generates two fields for a single currency field from Salesforce, the field with its original name, and another with the keyword 'static'. The field with the original name pulls the amount value directly from Salesforce. The 'static' field uses the convertCurrency function during ingestion, converting the amount value to your default currency set in your Salesforce account.

In your reports, the non-'static' currency fields will always be converted to the current dollar rate, while 'static' currency fields will remain as the resulting value from convertCurrency.

Example:

Let's say your default currency in your Salesforce organization is USD, and you have a field named deal_arr__custom with the value of 100 GBP. When HockeyStack pulls this data from Salesforce, it generates two fields - deal_arr__custom and deal_arr_static__custom . Inside the HockeyStack database, the resulting values of the two fields will look something like the following.

• { deal_arr__custom : 100, currency: GBP }

• { deal_arr_static__custom: <SFDC converted amount from convertCurrency(deal_arr__custom)>, currency: USD }

When you create a report using these 2 fields, HockeyStack will convert deal_arr__custom to USD with the most current exchange rate, and deal_arr_static__custom will not be affected by the current exchange rate, but pull value directly from our database.