This content has been marked as final. Show 4 replies
So you have the correct value, you just want to add a percentage symbol onto the end of it? Have you thought about doing this in the report definition?
Assuming you are using OBIEE 11g, when defining the analysis criteria, go to Column Properties for the measure, then to Data Format tab and Override Default Data Format to Percentage.
Please mark if helpful / correct,
This is not possible within the RPD, as percentage is not a datatype. However, when you override the column data format, use the "Save as Default" drop down to save the format as a system-wide default for the column.
As suggested above, adding the deciimal places in the formula is a neat trick to force the percentage to show decimal places properly. Not very good functionality I know, but the solution suggested works around this shortcoming nicely. I recall the same applied to OBIEE 10g.
Please mark if helpful / correct.