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!

Dividing two calculated fields

669029Jan 21 2009 — edited Feb 6 2009

Hi Folks,

I have an Requirement where in I have to Divide two Columns(calculated) in Custom Report. The Columns names are
# Opportunities Created and # Opportunities Won
both of the columns are Calculated and I am using "Count Distinct" aggregation rule so as to get the number.
Now the issue arises when I have to create a column where i have to do Opportunity Conversion Rate (# Opportunities Created / # Opportunities Won)

when I am trying to this conversion I am getting Error which states that an Integer calculation is performed on Non- Integer Columns

How can I achieve this functionality??

Thanks and Regards,
Amit Koul

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2009

Added on Jan 21 2009

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

8 comments

1,153 views