Num # is not working correctly

[Roberto_Licciardello]

Hello everybody,
I'm converting a text in the import script using this shape (which works on QlikView and gives me back a number):

if (isnum (KM_RETURN) = - 1, KM_RETURN, num (Num # (KM_RETURN, '#. #', '.', ','))) as KM_RETURN

Instead of returning me a number, it returns me a "?". If I use the same formula inside a column of a table the conversion takes place correctly.

Some idea?

Thank you.
Hello.

[JordyWegman]

Hi Roberto,

Just to be sure, Num#() and Num() are two different functions.

• Num#() is an interpreter function like all # functions ( Date#(), Time#() etc.)
• Num() is a formatting function ( Date(), Time() etc.)

If it's not working correctly, see if you interpret the data correctly. Probably it's not recognized.. What if you only use Num#() without the other parameters?

Jordy

Climber