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,
