Analysis measure keeps automatically rounding percentages
Summary.4768594% on the database is displayed as 4.80%. How do I change it?
".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.