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!

Comparable to excel AND function

937530Jan 14 2013 — edited Jan 14 2013

Right now I have a discoverer query that I export to excel and run an fairly simple function. What I want to do is just run this function/calculation in discoverer. In excel it looks like this

=IF(AND(K1>=59.58,L1>=25.25),"R",IF(AND(K1>=55,L1>=10),"Y",IF(AND(K1>=55,L1>=5),"G","W")))

I realize that in discoverer I will have to use CASE when... but I cannot find anything equivelent to the AND fuction. Any suggestions would be appriciated. Right now exporting and doing this in excel weekly is getting a little old.

THANKS!!

This post has been answered by Michael Armstrong-Smith on Jan 14 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 11 2013

Added on Jan 14 2013

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

2 comments

129 views