Categories
column to be able to display up to 5 decimals in EBS Bi publisher
Summary
column to be able to display up to 5 decimals in EBS Bi publisher
Content
Hi All,
I have number column in rtf template, column to be able to display up to 5 decimals
Using this Tex to display: 9,999,999.00 & Format: #,##0.00, but it is printing as 7,295.67
I want 7,295.67000
Could you please help me?
Answers
-
Use it in ur sql query
0 -
<span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">TO_CHAR</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">(<span style="font-weight: bold; font-size: 12px; font-family: Arial, Tahoma, Verdana; background-color: #f5f5f5; color: #000000;"><span class="hiddenSpellError" style="font-weight: inherit; font-style: inherit; font-family: inherit;">fieldname</span></span></span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">,</span><span class="pln" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;"> </span><span class="str" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #7d2727;">'9,999,999.99'</span><span class="pun" style="font-style: inherit; font-weight: inherit; font-family: inherit; color: #303336;">);</span>0 -
Or u can format in sql data model by using
https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/sql_elem.htm#34512
0 -
How to use to-char?
0 -
try this
<?format-number:fieldname;’999G999D99′?>
0 -
I have used
<?format-number:LINE_AMOUNT;'999G999D99999'?>
But still it is showing like this.
14,589.52
FYA...old code for LINE_AMOUNT
Could you please help me?
0 -
Hi Experts,
Could you please help me on this?
0 -
Have u tried to_char () in ur orginal query????
0 -
<?format-number(Line_number, '#,##0.00', 'myFMT')?>
0 -
Hi,
You can generate more than 2 decimals only for .xlsx output, For the other formats, maximum number of decimals is 2.
Note: If any of the replies in this thread were helpful/correct, kindly mark it accordingly as this would help others who can also benefit from it.
Regards,
Violeta
0