Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

column to be able to display up to 5 decimals in EBS Bi publisher

Received Response
295
Views
17
Comments
mist123
mist123 Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

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?

Tagged:
«1

Answers

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics Lead

    Use it in ur sql query

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics Lead

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

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics Lead

    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

  • mist123
    mist123 Rank 4 - Community Specialist

    How to use to-char?

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics Lead

    try this

    <?format-number:fieldname;’999G999D99′?>

    https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-7BD3C665-851A-43FE-BA2D-7501390D95AC.htm#BIPRD2566

  • mist123
    mist123 Rank 4 - Community Specialist

    I have used

    <?format-number:LINE_AMOUNT;'999G999D99999'?>

    But still it is showing like this.

    14,589.52

    FYA...old code for LINE_AMOUNT

    image

    Could you please help me?

  • mist123
    mist123 Rank 4 - Community Specialist

    Hi Experts,

    Could you please help me on this?

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics Lead

    Have u tried to_char () in ur orginal query????

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics Lead 
    <?format-number(Line_number, '#,##0.00', 'myFMT')?>
  • Violeta F
    Violeta F Rank 4 - Community Specialist

    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