Exponents not showing as numbers in Qlikview

[#1]

Does anyone know how to convert exponents into actual numbers?

Example: it shows '3.4115809049999998E+03'

[ashfaq_haseeb]

Hi,

What is the length of your number?

You can try with

num(Field, '#,###,###.00') as Field

Regards

ASHFAQ

[MarcoWedel]

Hi,

works out-of-the-box:

however check your decimal seperator in the script:

with my default value (comma), it works like this:

hope this helps

regards

Marco

[jagan]

Hi,

Try like this

=Num( '3.4115809049999998E+03')

OR

=Num(FieldName)

OR

=Num(FieldName, '#,###.00') - Formatting the converted number

Regards,

Jagan.