2 Replies Latest reply: Jan 14, 2013 3:01 PM by 937530 RSS

    Comparable to excel AND function

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