Can we do currecny conversion in domo if yes how

Can we do currecny conversion in domo if yes how

Comments

  • BlueRooster
    BlueRooster Domo Employee

    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.

  • 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.  

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
This discussion has been closed.