Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Brazil | 3,12 | 80 | Hardware |
Brazil | 3,12 | 12 | Others |
Brazil | 3,12 | -99 | Outsourced |
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 |
Argentina | 8,7918 | 11 | Hardware |
Argentina | 8,7918 | 1 | Others |
Argentina | 8,7918 | -4 | Outsourced |
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,