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 / 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,
try
Sum( Local_Value / Rate_USD )