5 Replies Latest reply: Dec 20, 2011 12:40 PM by dgonzalez RSS

    Breaking a formula to create expression

      I have a problem not solved and esoerio as someone can provide some solution. I have a table that contains records with mathematical formulas like this:

       

      Field 1     Field 2

      REG1      A

      REG2      B

      REG3     A + B

       

      REG4      C

      REG5      A + B + C

       

      And another trabla with:

       

      Field 2     Amount

      A                100

      B                20

      C                120

      A                50

      A                250

      B                300

       

      As I can write the expression to get this result, considering that the basic operations arepossible (+, -, *, /) and can be combined into one operation.

       

      Field 1     Total

      REG1      400

      REG2      320

      REG3      720

      REG4      120

      REG5      840