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