Salesforce - Converted fieldss

[JDong]

Hi Team,

I am working with SFDC and have a few fields that are converted

Like we see above we have the fee field that is converted. Any idea how to derive this calculated field in Alteryx ?

Also I am new to SFDC and do not know how to read this calculation.

Thanks

[danilang · Accepted solution]

Hi @JDong 

The converted fields are the value in your local currency.  As to the process used, it's probably a proprietary Sales Force secret, but they most likely use look up tables to make the conversion.  You can find more details on the SalesForce Currency help page

To reproduce this process, check out the example here that calls the free xe.com currency conversion API

Dan