Scientific Notation format issue

alec1982 — Thu, 02 Apr 2015 14:41:43 GMT

Hi all,

I have a formula that return scientific notation format. I used the below formula to change it to a number but the issue is that the number i get show comma instead of dot (0,00022)..

Anyone knows how to format it to be decimal and show the dot instead of comma?

num(sum([Field1])/sum({1} [Field1]),'#,#######',',','.')

the actual numbers I have

35420 / 1566041781.9116 and it returns 2.2617531926105e-005

when applying the above formula it returns 0,0000226

the expected result should be 0.00022618

Re: Scientific Notation format issue

alec1982 — Thu, 02 Apr 2015 15:56:45 GMT

I found the answer:)

=num(35420 / 1566041781.9116,'#,##0.0000000000000')

topic Scientific Notation format issue in QlikView

Scientific Notation format issue

Re: Scientific Notation format issue