How to convert an exponential no to decimal

[kamalqlik]

Hi friends, I m facing a problem .Please suggest me the solution for the problem.

hey guys,how to convert an exponential number to decimal in

qlikview?

i tried mantissa*pow(10,exp) formula but mantissa that i

separate from the original field

,it is showing that it is neither a text nor a number.

Thanks in advance

Kamal Naithani

[#2]

But what can i do?, i used the code from your post..

[#3]

what version are you on ?

[#4]

11.00.11154.0

I got it working:

Num(Left(@5, Index(@5, 'E') -1) * Pow(10, TextBetween(@5, 'E', ''))) as meas,

     Num(Left(@6, Index(@6, 'E') -1) * Pow(10, TextBetween(@6, 'E', ''))) as mean,

     Num(Left(@7, Index(@7, 'E') -1) * Pow(10, TextBetween(@7, 'E', ''))) as lower,

     Num(Left(@8, Index(@8, 'E') -1) * Pow(10, TextBetween(@8, 'E', ''))) as upper,

For now i'm happy, although it would have been easier to just say "this is a number".....