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

    Comparable to excel AND function

      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.