Comparable to excel AND function

937530 Jan 14, 2013 12:21 PM

Currently Being Moderated

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!!

1. Re: Comparable to excel AND function

michael armstrong-smith Jan 14, 2013 12:50 PM (in response to 937530)

Currently Being Moderated

Hello
You can use multiple AND statements in a CASE statement like this:

CASE
WHEN K1>=59.58 AND L1>=25.25 THEN "R"
WHEN K1>=55 AND L1>=10 THEN "Y"
WHEN K1>=55 AND L1>=5 THEN "G"
ELSE "W"
END

Notice how you can keep repeating the WHEN clause. There has to be at least one and at the end it makes good sense to have an ELSE statement as a catch all.

Hope this helps
Best wishes
Michael
Report Abuse

Like (0)
2. Re: Comparable to excel AND function

937530 Jan 14, 2013 1:01 PM (in response to michael armstrong-smith)

Currently Being Moderated

Perfect~! Couldn't be easier. Thank you very much
Report Abuse

Like (0)

Go to original post

Actions

Legend

Correct Answers - 10 points
Helpful Answers - 5 points