Cast as number

[#1]

Hi guys

Im stuck with a pretty simple issue.

I have to load from excel table a factor like this 0,0016.

When I load in QV it interprets that value as 0.

Im trying to use the num and num# but can't hit.

Someone know what is the correct format?

Thanks

[#2]

In order to clasify.

I need to use it as 0.0016

[#3]

can you post the exaple?So i can help you

[jonathandienst]

Hi

Use this in your load script for the table containing factor:

     Num(Num#(factor, '0,0000', '',', ' '), '0.0000', '.', ' ') as factor

Hope that helps

Jonathan