Skip to Main Content
Forums

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

Comments

This is a fabulous project, I have had problems with using java for real time applications because of the garbage collection mechanism.  I have used configuration techniques to minimize garbage collection, I'm wondering if you could address that here?

unknown-3392251

tanx is soo goood

طراحی سایت

Kashif Sohail

Is there any starter kit available for beginners?

Jose Cruz

Is there any starter kit available for beginners?

Dear Kashif

No, there isn't, because it is one of my hobby projects that I share with Java ME community.

If you need I can help you about your needs.

Best Regards

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 11 2013
Added on Jan 14 2013
#business-intelligence-applications, #business-intelligence-foundation, #discoverer
2 comments
128 views