Skip to Main Content

Oracle Database Discussions

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!

Case statement for interactive report error

652581Jul 31 2008 — edited Jul 31 2008
The case computation does not work for me :
statement
CASE WHEN G = 7 THEN G ELSE C END

Error message ' Invalid computation expression. THEN'

It does not seem to matter what the case statement is IE :
CASE WHEN I = 'DEMO' THEN 'LOW' ELSE 'HIGH' END

I have tried this on the Sample Application that is installed on my oracle workspace account

Column G : order number ( number)
Column C:order total (Number)
Column I:sales Rep ( String)

Can someone please tell me what I am doing wrong ?
Thanks

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 28 2008
Added on Jul 31 2008
4 comments
526 views