Invalid expression by using Sum(A*B)

[#1]

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

[#2]

Please read the post which i found http://community.qlik.com/message/134943#134943

let see if it can solve your problem.

[#3]

Thanksfor this  Michael somehow it's helpful why it is stuvked.