Why Bi Publisher template viewer for etext template showing number in exponential form?
Hi,
I am trying to display below value using Bi Publisher etext template and using template viewer to check the sample output,but it is displaying number in exponential form. Actually I want it to show real number. Please let me know if there is any setting that needs to be done for this.
1000000000000000+TO_NUMBER(SUBSTR(12345678,1,8))
Output value is for the above addition is showing up as 1.000000012345678E15
expected value is 1000000012345678.
I am trying to display below value using Bi Publisher etext template and using template viewer to check the sample output,but it is displaying number in exponential form. Actually I want it to show real number. Please let me know if there is any setting that needs to be done for this.
1000000000000000+TO_NUMBER(SUBSTR(12345678,1,8))
Output value is for the above addition is showing up as 1.000000012345678E15
expected value is 1000000012345678.
0