Skip to Content
avatar image
Former Member

Currency Converstion Report Best Practice

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 11, 2017 at 07:49 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 11, 2017 at 09:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

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

  • Jul 11, 2017 at 07:32 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 11, 2017 at 08:00 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 11, 2017 at 07:47 AM

    Thanks Vadim.

    I know that I use DM to convert everything.

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

    Add comment
    10|10000 characters needed characters exceeded