Currency Converstion Report Best Practice

[Former Member]

Dear All,

I have to build a report (not input) for see the amounts in one currency.

We have models across America where they are inputting in LC, but, somehow they want to see a report converting all to one currency (and it should be dynamic)

What are the best way to achieve this? (if excel built even better)

For exampleconvertion-rate.jpg

Thanks.

Regards,

[Former Member · Accepted solution]

Sorry DM you mean DMP calling a Script logic, right?

[former_member186338 · Accepted solution]

Yes, DM to run script for currency conversion.

[fgavarini]

Hi Pheno,

I guess calculating currency conversion directly in a report is not a best practice at all.

However, if you want to do so, I would suggest to create a report retrieving the numbers in LC, then adding a Local member column with EPMRetrieveData to get your rates from the rate model and another local member to calculate your 'on the fly' currency conversion.

I hope this helps

Rgds

Francesco

[former_member186338]

"EPMRetrieveData to get your rates" - this will terribly slow down the report...

Better to use separate report for the same periods and category from rates model.

[former_member186338]

In general I don't think that it's a good idea to perform currency conversion using Excel formulas.

You will have to:

1. Create a separate report to get all rates for all currencies for all required periods.

2. Use a local member to get a currency property of the entity (for LC)

3. Use VLOOKUP to get rates and perform calculations.

[Former Member]

Thanks Vadim.

I know that I use DM to convert everything.

But, I wanted to do directly in Excel wise, like Real time!

[former_member186338]

Sorry, but what's the issue? You can run DM for currency conversion to many currencies....