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

Oracle BI EE analisys format number

Received Response
11
Views
3
Comments
user9159846
user9159846 Rank 3 - Community Apprentice
edited Aug 13, 2024 6:04PM in Oracle Analytics Cloud and Server

Hi! I create analisys and when create the totals field, I can not create a custom number format: see picture

Снимок.PNG

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    You could go to the Advanced tab of the report and edit the Analysis XML, like below

    <saw:dataFormat xsi:type="saw:custom" customFormat="# ## ###"/>

  • user9159846
    user9159846 Rank 3 - Community Apprentice

    Dear Sherry George, please tell me between what tags i need to insert your TAG : <saw:dataFormat xsi:type="saw:custom" customFormat="# ## ###"/>.

    I find in xml:

    <saw:displayGrandTotals>     

    <saw:displayGrandTotal id="gt_row" grandTotalPosition="after"/></saw:displayGrandTotals>

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    ok, as far as I know the grand total value will get displayed in the same format as the column the total is based on. What version of OBIEE is this?