5 Replies Latest reply: Jun 27, 2016 1:10 PM by Clever Anjos RSS

    Problema dividindo ou multiplicando - dimensoes diferentes

    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:

       

       

         

       


       

      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,