Converting text data type into num qliksense

[Aspiring_Developer]

Hello all,

I have below table:-

I am trying to do the sum of closed_wkg_days but it is coming 0 . When I take the count it populates the number.

I am assuming that data type of my field is in text format . Hence, in the backend script  I used num(closed_wkg_days) but it did not worked.

Can anyone please help me with this ?

Thanks in advance

[brunobertels · Accepted solution]

Hi 

try with num#(closed_wkg_days)