How to convert scientific number to decimal in BI report?

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')