Each of my stores has a differnt currency. How do I bring them all into one report / currency?

[saiadharap71b3]

I have a multiple store setup of and each store has a different currency.

How can I bring their sales data into one report and normalize the currency to USD.

Is there a table that has all the currency conversions and update constantly that I can bring in?

[toniagency82ed]

It kind of depends if you have multiple currencies or multiple base currencies. In any case, such reporting is best handled by systems outside of Magento. You can use APIs or export your data into your preferred business inteligence system.

[saiadharap71b3]

Hey! So I'm using Adobe BI already, does it have this functionality built in somewhere?

[glo11486ad4f3e · Accepted solution]

Hi saiadharap71b3,

Thank you for reaching out to us.

Adobe Commerce Intelligence (aka MBI) has a built-it feature to convert currency within Data Warehouse section.

To implement it, you can create calculated column that make use of automatic conversion and store the converted value as an additional column to the same table (for example sales_order).

Further, you can make use of these calculated columns to create necessary metrics & reports.

For more information, please refer to our online help.

https://experienceleague.adobe.com/en/docs/commerce-business-intelligence/mbi/analyze/warehouse-mana...