Exponential Value Conversion at front end

[abhaysingh]

Hey Guys,

I have one calculation in which i m multiplying two value,

A * B = 1.7741025325602e+016

i want to convert it into number..How can i handle them at front end?

[arulsettu]

may be this in text object

=num('1.7741025325602e+016','(dec)')

[Chanty4u]

=Num(Replace('4.42E+11', ',', '.'), '(dec)')

nd chk dis

Exponents not showing as numbers in Qlikview

Re: Convert scientific/exponential format to number value

[MK_QSL]

Conversion of Exponential Notation to Decimal numbers

[abhaysingh]

Not Working in My scenario at front end calculation

[jonathandienst]

Qlikview can represent numbers up to 14 digits without exponential notation, Your number is 16 digits, so you cannot get it displayed without an exponent.

By the way it is a number. e+016 means multiply the mantissa (1.7741025325602) by 10^16