4 Replies Latest reply on Oct 16, 2012 5:17 PM by Andy Coates

# Calculateing Percentage For Logical Column

Hi All,

I Created New logical Column In Bmm Layer.I want Display Data In Percentage.

Ex: new column=(Recevice Amount/SUM(Recevice Amount))*100

It Working Fine But I want Dispaly The Data In Percentage.

Please Let Me Know How To Do This.
• ###### 1. Re: Calculateing Percentage For Logical Column
Hi,

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.

Andy

www.project.eu.com
• ###### 2. Re: Calculateing Percentage For Logical Column
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..
• ###### 3. Re: Calculateing Percentage For Logical Column
Use this

column=((Recevice Amount)*1.00/SUM(Recevice Amount))*100.0
This should work

• ###### 4. Re: Calculateing Percentage For Logical Column
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.