Oracle Analytics

Get Involved. Join the Conversation.

Topic

    Greg
    Analysis measure keeps automatically rounding percentages
    Topic posted April 12, 2019 by GregGreen Ribbon: 100+ Points, last edited September 11, 2019, tagged Packaging & Licensing, Reporting 
    47 Views
    Title:
    Analysis measure keeps automatically rounding percentages
    Summary:
    .4768594% on the database is displayed as 4.80%. How do I change it?
    Content:

    ".4764594%" on the database side is displayed as 4.80% in an OAC Analysis. How do I change it to show 4.76%? On the application side, I tried modifying the Column Properties > Data Format > Override Default Data Format. Then I chose Treat Number as Percentage and Decimal Places 2 but nogo. I checked that the data format is a DOUBLE in the BI Admin Tool. I do see an option to change the data type the BI Admin Tool to one of the following: "DATE, INT, LONGVARCHAR,UNKNOWN, VARCHAR". Not sure if that would resolve the issue.

     

    Thanks

    G

     

    Version:
    OAC Classic