11 Replies Latest reply: Jul 10, 2013 4:49 AM by Amelia D RSS

    Invalid expression by using Sum(A*B)

      Hi All

       

      I have a table structure like as below:

       

      ColumnA    ColumnB   ColumnC    

      AAA           10             2

      BBB            20            3

      CC              0              4

       

      How does i can acheive the following result:

       

       

      ColumnA    ColumnB   ColumnC     ColumnD

      AAA           10             2                20

      BBB            20            3                60

      CC              0              4                0

       

       

      i try the scripts Sum(ColumnB* ColumnC) as ColumnD, however, it return invalid expression after reload.

       

      Would you please kindly advise?

       

      MC