Different condition inside of AGGR()

[#1]

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

[#2 · Accepted solution]

if(order = 3 or order = 20 or order = 49, date(....

[CELAMBARASAN]

Hi,

     Try with match function

AGGR

(

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

     order_status

)

Celambarasan