Documents for QlikView related information.
The below script helps in converting the Exponential Notation (or Scientific Notation) numbers to Decimal numbers
Num(ENumber, '(dec)') AS Decimal
Hope this helps you.
Useful information... TFS Jagan...!
Thanks Jagan.. is very informative..
Hello Jagan, Thanks for the doc. But how do we represent negative exponent with only 2 decimals? for eg, in the above example, how do we show '1.2600000000000000E-02' as only '0.012'?. Thanks.