You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to convert scientific number to decimal in BI report?

Accepted answer
1
Views
1
Comments

Summary:

In a report for corporate rate, value is fetched as 6.666666666666666666666666666666666667E-02

We tried with using to_number to convert this but it kept giving invalid number error.

How can we convert this?


Content (required):

In a report for corporate rate, value is fetched as 6.666666666666666666666666666666666667E-02

We tried with using to_number to convert this but it kept giving invalid number error,please see below code snippet.

How can we convert this?

Version (include the version you are using, if applicable):

21C

Code Snippet (add any code snippets that support your topic, if applicable):

to_number(rate,'9G999D99')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!