topic Re: Exponents not showing as numbers in Qlikview in QlikView

Exponents not showing as numbers in Qlikview

Wed, 27 Aug 2014 16:55:27 GMT

Does anyone know how to convert exponents into actual numbers?

Example: it shows '3.4115809049999998E+03'

ashfaq_haseeb — Wed, 27 Aug 2014 17:14:49 GMT

Hi,

What is the length of your number?

You can try with

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

Regards

ASHFAQ

MarcoWedel — Thu, 28 Aug 2014 00:17:09 GMT

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 — Thu, 28 Aug 2014 01:37:02 GMT

Hi,

Try like this

=Num( '3.4115809049999998E+03')

=Num(FieldName)

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

Regards,

Jagan.