Format string to number

[jacek_k]

Script:

pick(WildMatch(currency,'XX'),'0.099') as Value,

Later, when I want use that column a do some calculation - a see 0.099 but qlik change number to 99.

I try num:

num(pick(WildMatch(currency,'XX'),'0.099')), num# etc

[rubenmarin]

Hi, have you tried without the simple quotes in number?: pick(WildMatch(currency,'XX'),0.099) as Value,