2 Replies Latest reply: Apr 16, 2012 12:12 PM by Celambarasan Adhimulam RSS

    Different condition inside of AGGR()

      I have this code in the expessen screen:

       

      AGGR

      (

           IF(order=3, DATE(MAX(ordertime)), NULL()),

           order_status

      )

       

      I need to have order with value 3, 20 and 49 and I don't know how to do it

       

      I tried using lots of IF inside of AGGR but I failed.

       

      AGGR

      (

           IF(order in (3, 20, 49), DATE(MAX(ordertime)), NULL()),

           order_status

      ) but I failed.

       

      I must have AGGR in the end of the code.

       

      Any good idea?

       

      // JJ