sum returns 0

[diane_yu]

Hello all,

I've created pivot chart to sum the Cost_per_Enc field.  In the database, this field is a decimal (18,2).  In expression, I coded 

=sum(Cost_per_Enc).  In straight table, it displays proper $$ amount.  It seems like Qlik is treating this field as varchar.  How do I convert them so I can sum the field?

Thank you for your help in advance!

Di

[diane_yu]

Good morning yusuf,

I changed to proper DMISID and it worked. Thank you.

Di

[ynomani8223]

I used the following set Analysis in Qlik Sense

sum({<color_code={"Red" }> } color_code) but getting 0 in color_code ( 4th column).

I should see only Red related rows. Where I am doing wrong?

[swati_gupta]

Could you please tell how did you solve this?