2 Replies Latest reply: May 7, 2012 12:37 PM by Peyman Azimabadi RSS

    Expression with operator from table

    Peyman Azimabadi

      Hi all,

      my data model is something like this :

       

       

      Name        O        V2

      ----------+------+--------------

      Jack     |    *   |     2

      John     |    /   |     4

       

       

      Name       V1

      ----------+--------

      Jack     |  100

      Jack     |  200

      John     |    50

      John     |  230

       

      i need an expression that calculate the value of ( sum(V1) O V2 ) for each row. This means that i need :

       

      Jack : 300 * 2 = 600

      John : 280 / 4 = 70

       

      i tested sum(v1) $(O) $(V2) , but it dosen't work.

      i will appreciate any idea.

       

      Best regards

      Peyman