Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

Scientific Notation format issue

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

1 Solution

Accepted Solutions
alec1982
Specialist II
Specialist II
Author

I found the answer:)

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

View solution in original post

1 Reply
alec1982
Specialist II
Specialist II
Author

I found the answer:)

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