2 Replies Latest reply: Apr 21, 2013 9:58 AM by jörn kunz RSS

    Calculating Currency in the Sum column

      Hej together,

       

      i have a column with currency and a cloumn amount in one table

       

      AmountCurrecncy
      1212EUR
      2145USD

       

      The second Table is the USD and the eychange rate.

       

      CurrencyChange Rate
      USD0,8

       

       

      Well, i want the Amount 2145 with the currency USD that calculate the amount with the change rate (0,8) an refresh the amount 2145 with the new amount of the change rate.

       

      Could you help me.

       

      Thank you.