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,
It Is Any Posible In Rpd Side And I Doing Same Thing Whn I am selecting Data Format Is percentage and Decimal is 2.but it will not Disply Correct values.
Ex: my Calculation Like This
4/21*100= 19.04 But Display Like This 19.00%
Please Let me Know How To do this..
Use this1 person found this helpful
column=((Recevice Amount)*1.00/SUM(Recevice Amount))*100.0
This should work
Pls mark correct/helpful
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.1 person found this helpful
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.