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!

SUM-ing text/string using case statement

ZFMA86Mar 7 2013 — edited Mar 7 2013

I had thought I solved this in this thread 10892374

Seeking advice again...The formula works fine when adding it as a column (meaning it marks records with 'Y' and 'N' like it should).

Now when I go to SUM it, it's giving me all 0's again:

SUM(CASE WHEN "Pending Claim - Suspense"."Suspense Reason" LIKE '%Pending Record%' THEN 1 ELSE 0 END)

I thought I had solved it; apparently not. Any advice?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2013

Added on Mar 7 2013

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

6 comments

1,049 views