Numbers Formatting

[#1]

Does click view support Scientic Formating? I want to display very small number as 2.25E-02.

0.0225 = 2.25E-02

[pover]

In the number tab if you set the expression to type number and give it a low precision scientific notation will be used.

[#3]

Hi,

You can try by using 'num' function

Ex:

num(2.25E-02) It will give you the result you expceting.Try and let me know

Thanks & Regards

Jai

[#4]

In the image I want the display to look like the Format display, I can't seem to do that?

[pover]

There should be a way to do this in the number format, but using 'e' doesn't seem to work. You can try this workaround that works when the number is less than 1 and greater than 0. The result it returns is a string.

=num(PurgeChar(num(0.00584),'.'))/pow(10,len(num(PurgeChar(num(0.00584),'.')))-1)
&'e'&(-(len(num(0.00584))-len(num(PurgeChar(num(0.00584),'.')))-1))

Just replace num(0.00584) with the field that you want to convert and you might need an if to evaluate if it is less than 1. Playing with this same type of formula, you should be able to format other numbers less than 0 or greater than 1.

Regards.