Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Division between two columns in pivot table in Answers

855391Jul 21 2011 — edited Jul 22 2011

Hi all
In answers
if I have two columns in my pivot table say column A and Column B, how can I use a division of Column B by Column A to derive Column C. I am unable to do that using the "New Calculated column feature" or in the criteria section. I keep getting either 0 or 1. I even tried changing the format to show two decimal places and am still unable to get the result.

Thanks
B

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 19 2011

Added on Jul 21 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

5 comments

2,677 views