Business Intelligence

Get Involved. Join the Conversation.

Topic

    Greg
    Analysis measure keeps automatically rounding percentages
    Topic posted April 12, 2019 by Greg, tagged Business Intelligence, OAC Enterprise Edition 
    41 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