15 Replies Latest reply: Feb 28, 2013 12:48 AM by Rob Wunderlich RSS

    Getting the correct value [Scripting]

      Hello all,

       

       

      I would like to describe my tables below:

       

      HEADER TABLE:

      idcurrency codedate
      1USD2/23/2013
      2AU2/20/2013

       

      CURRENCY TABLE: (everyday it updates)

      currency coderate
      starting date
      USD502/23/2013

      AU

      40

      2/23/2013

      USD552/24/2013

       

      LINES TABLE:

       

      idamount
      11000
      2270

       

      Now my problem, the chart that I create is the sum of the amount in the LINES TABLE.

      I need to output the computed amount not the raw amount.

       

       

      Any ideas?

       

       

      Regards,

      Donna