This guide shows you how to use the Currency Converter in effectmanager.
This tutorial provides step-by-step instructions on using the Currency Converter feature in effectmanager, enabling you to report in Euro.
If you are interested in having a PowerBi report where you can report in Euro, then please contact support@effectmanager.com
In the tutorial we will go through the following:
- How to add Exchange Rates
- How to edit Exchange Rates
- How to remove Exchange Rates
- How Exchange Rates are used in reporting
How to add exchange rates
The Currency Table is a user-friendly feature that allows you to add, edit, and remove exchange rates effortlessly. To add an exchange rate, navigate to Settings/Currency. Once there, follow these steps:
1. Click on the "Add" button to create a new line in the table.
2. In the "Currency" field, choose from the available options:
- EUR/DKK
- EUR/SEK
- EUR/NOK
3. Enter the exchange rate value for the selected currency in the "Exchange rate" field.
Numerical values with dot separator.
4. Specify the year for which this currency rate is valid in the "Year" field.
Just so you know, the combination of Currency and Year must be unique to ensure accuracy and reliability.
👍Pro-tip: If you add a duplicate you will see a pop-up informing you of the combination of Year and Currency. Pressing "Update" will update the existing record. Pressing "Cancel" will discard the changes you input.
5. Finish by pressing "Update". 
How to edit exchange rates
To edit an exchange rate, navigate to Settings/Currency. Once there, follow these simple steps:
1. Select the exchange rate that you want to edit.
2. Click on the "Edit" button to open the line in the table and make your desired changes.
3. Complete the edit by pressing "Update."
4. After pressing "Update," the system validates the entry, ensuring that the combination of Currency and Year is unique for accuracy and reliability.
Pressing "Update" will update the existing record. Pressing "Cancel" will discard the changes you input.
🔴OBS! If there is a duplicate entry for Currency and Year, your edits will not be applied.
How to remove the exchange rate
To remove an exchange rate, navigate to Settings/Currency. Once there, follow these simple steps:
1. Select the exchange rate that you want to remove.
👍Pro-tip: You can select multiple lines by pressing CTRL on your Keyboard and selecting the lines to remove.
2. Click on the "Remove" button.
3. Complete the removal by confirming the rows for deletion in the pop-up.
After pressing "Yes," the selected row(s) are removed from your currency table and will no longer be applied.
How Exchange Rates are used in reporting
The exchange rates you input to the Currency table are applied in the following Key Figures, making them available for Power BI reporting in effectmanager.
- Turnover EUR ex VAT
- Turnover EUR ex VAT - last year
- Turnover EUR ex VAT - benchmark
- Turnover EUR ex VAT YTD
- Turnover EUR ex VAT LYTD
- Index Turnover EUR ex VAT YTD
- Index Turnover ex VAT EUR
🔴OBS! If you have not input an Exchange Rate for a year, conversion factor 1 is used in the calculation.
If you are interested in Power BI reporting in Euro, please reach out to support@effectmanager.com, and we will connect you with your Customer Success Manager.