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!

An arithmetic operation is being carried out on a non-numeric type

sliderrulesMar 8 2011 — edited Mar 10 2011

Hi,

I have a pivot table report that contains the following layout

Columns - Month Name
Rows - Market
Measures - new proposals, approvals, conversions (aggregation rule is COUNTS)

I am trying to create a new columns that calculates the approval rate - approvals/new proposals

I have written the following statement in fx of a new column, the SQL is derived from the columns approvals and new proposals

case when "Agreement Fact".Status in('CAP', 'LIV') then "Agreement Fact"."Agreement Num" else null end /"Agreement Fact"."Agreement Num"

I get the following error

An arithmetic operation is being carried out on a non-numeric type

Can anyone help?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2011

Added on Mar 8 2011

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

10 comments

1,459 views