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?
Thanks and
best Regards,
