Scientific Notation format issue

[alec1982]

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

[alec1982 · Accepted solution]

I found the answer:)

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