Solving problem - diving values and using different dimensions
Hello All!
I'm having a problem when dividing values in Local Curreny by USD Rate for different countries in order to have them all in American Dolar Currency. I using the expression:
Sum(Local_Value)/(Rate_USD)
Below you can see my table:
Country
Rate_USD
Local_Value
Classification
Brazil
3,12
0
Depreciation / Amortization
Brazil
3,12
80
Hardware
Brazil
3,12
12
Others
Brazil
3,12
-99
Outsourced Services
Brazil
3,12
58
People
Brazil
3,12
72
Software
Brazil
3,12
-17
Telecom
Brazil
3,12
-4
Training
Brazil
3,12
-7
Travel
Argentina
8,7918
-22
Contractors
Argentina
8,7918
-33
Depreciation /
Amortization
Argentina
8,7918
11
Hardware
Argentina
8,7918
1
Others
Argentina
8,7918
-4
Outsourced Services
Argentina
8,7918
1
People
Argentina
8,7918
-14
Software
Argentina
8,7918
1
Travel
The problem is that Using this expression I have the righ values if I select a charge using dimension as Contries, but if I change the dimention to Classification, the values get all wrong.
Could you suggest me how could I fix my expression so that no matter what kind of dimention, I'd have the right values always?
