Oracle Analytics Publisher Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Publisher Forum

Categories

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

RTF Bar graph not showing values upto 2 Decimal.

Accepted answer
21
Views
1
Comments
A Sirisha
A Sirisha Rank 1 - Community Starter
in Oracle Analytics Publisher Forum

I am generating a report with an RTF template and a BI Publisher query where values are rounded to 2 decimal places using the ROUND function. In the RTF template, I am using the <ViewFormat decimalDigit="2" decimalDigitUsed="true" /> tag to ensure values display with 2 decimal places. Despite these settings, some values in the bar graph are still showing up to 3 decimal places. How can I ensure that all values are consistently rounded and displayed to 2 decimal places?

Best Answer

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics & AI Strategist
    Answer ✓

    Hi @A Sirisha

    You can try to

    Use the function xdoxslt:round() or xdofx:round()  in template file to round the number.

    Number Rounding Is Not Correct In R12.1.3 XML Publisher Reports (Doc ID 1551338.1)

    Regards,

    Arjun