1 Reply Latest reply: May 19, 2015 12:04 PM by Massimo Grossi RSS

    Problem when divinding / multiplying

    Silvia Assuncao


      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:

       

         

       

      CountryRate_USDLocal_ValueClassification
      Brazil3,120Depreciation / Amortization
      Brazil3,1280Hardware
      Brazil3,1212Others
      Brazil3,12-99Outsourced Services
      Brazil3,1258People
      Brazil3,1272Software
      Brazil3,12-17Telecom
      Brazil3,12-4Training
      Brazil3,12-7Travel
      Argentina8,7918-22Contractors
      Argentina8,7918-33Depreciation /
        Amortization
      Argentina8,791811Hardware
      Argentina8,79181Others
      Argentina8,7918-4Outsourced Services
      Argentina8,79181People
      Argentina8,7918-14Software
      Argentina8,79181Travel

       

      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,