Perhaps Qlik has recognized the values as numbers but as text. That could explain, why they can't be multiplied.
You could try making expressions that Sum the fields.
Hello Jfkinspari, as below pic indicated, i have tried with with various means of NUM(), Evaluate() etc, as red square circled expressions, but all failed, it gave the empty cells like red arrowed. what could be the reasons??
the original PUR_Currency_1 is like picture right side showed.
kindly please let me know if you have the solution. thanks