Char to num coversion

[#1]

Hi,

I have a number as a character 1.25 and I need to sum all data. How do I convert this char to a number in my script?

num() gives a - in stead of a number.

Greetings,

Ruud

[Gysbert_Wassenaar]

Use the num# function. It takes a string and you can specify the format so the string can be made a number.

[manideep78]

No problem. No need to convert that into number. QlikView automatically treats it as a Number. QlikView doesn't have data types.

Still you are facing any probelm use Num#() function.

refer help for this.

[#4 · Accepted solution]

num#(1.25, '#.##') did the trick  where 1.25 is a value of a datafield called Uren  -> formula: num#(Uren, '#.##')

Thanx all!