Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I found the answer:)
=num(35420 / 1566041781.9116,'#,##0.0000000000000')
I found the answer:)
=num(35420 / 1566041781.9116,'#,##0.0000000000000')