Convert Local Currency

Each individual country enters data in their local currencies. However, for the reporting in USD, it is to be done at Region level only. There is no need for Country level.
Right now, I managed to convert at Country level (REP05) and the Region data will automatically be rolled up.

If I do not want to store converted data at Country level and I would just want to report in USD at Region level, how can this be done?

Accepted answers

fabien.junod

Hello @Star

You are right, since the FX is at the country level, you need that level for the USD conversion.

After you convert to USD , as @nathan_rudman suggested it, you can create a reporting module at the G1 level.

nathan_rudman

if you are trying to save space, you can't here.
your FX is at the country level, so you have to calculate at the lowest level.
What you could do is calculate it in a module without summary, so only G3 counts, and then SUM it up to a module that has just G1, but I don't recommend it as you are just reproducing what the auto summary is doing. Only if you are very hungry for space

All comments

nathan_rudman

Hi,

Your level 2 is part of the hierarchy, you cannot simply remove it from all calculations.

However you can create a module that only using G1, so it won't use the space of the levels below and will not show them.

Star

@nathan_rudman
Tried using G1 in a module but seems like the calculation for countries is still required in order for G1 to be calculated, which in the example below would use just as much space.

In this instance,

REP05 - Test 2 --> Sales Revenue - Converted Region's formula is ''REP05 Local Currency P&L - Test 1'.'Sales Revenue - Converted'[SUM: 'SYS03 Country Details'.Region]' and

REP05 - Test 1--> Sales Revenue - Converted's formula is 'Sales Revenue * 'FX01 Currency Rates'.Rates[LOOKUP: 'SYS03 Country Details'.Local Currency]'

Not sure how your suggestion works. Would you be able to provide more information?

fabien.junod

Hello @Star

You are right, since the FX is at the country level, you need that level for the USD conversion.

After you convert to USD , as @nathan_rudman suggested it, you can create a reporting module at the G1 level.

nathan_rudman

Star

@fabien.junod , @nathan_rudman

Thanks for the replies and confirmation. Appreciate them.

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…