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
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.
You can use multiple AND statements in a CASE statement like this:
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"
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