Can we do currecny conversion in domo if yes how

user09710

Can we do currecny conversion in domo if yes how

Valiant

In order to do currency conversions you would need to first add the conversion data to your Domo instance.

 

There is a free connector called Open Exchange Rates that you can use. When setting it up it as asks what your base currency is. The dataset it then gives you is what you can then use in ETL or SQL transforms to adjust your currency's as needed.

 

Here's the connector documentation:

https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_Finance/Open_Exchange_Rates_Connector

Hope that helps,
Valiant

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

DataMaven

Thanks for sharing that resource @Valiant !  I have a table with the annual rates our company uses for each year.  It'll be nice to be able to also incorporate fresh rates.  This would even make it possible to build a tracker to see when rates change substantially, using a recursive query.