if in set analysis?

[ioannagr]

Hi all,

I have this expression

=aggr(if(aggr(Sum({<[orderdate]= {'$(=Date(max([orderdate]-1),'DD/MM/YYYY'))'},[availability]={'available'}>} [sales]),[client])>0 or aggr(Sum({<[orderdate]= {'$(=Date(max([orderdate]-1),'DD/MM/YYYY'))'},[availability]={'na'}>} [sales]),[client])>0, [client]),[client])

but now i want to do this check:

if (max[orderdate timestamp]< max(timestamp([orderdate], 'DD/MM/YYYY 08:00.00.000000'),max(date(orderdate),'DD/MM/YYYY') , max(date(orderdate)-1,'DD/MM/YYYY') 

I don't know where to implement this check in the above....

does anyone know how i can do it?

[QFabian]

Hi, in ordere tu do the sum, all of your expression should be envolved in another sum()

=sum(aggr(if(aggr(Sum({<[orderdate]= {'$(=Date(max([orderdate]-1),'DD/MM/YYYY'))'},[availability]={'available'}>} [sales]),[client])>0 or aggr(Sum({<[orderdate]= {'$(=Date(max([orderdate]-1),'DD/MM/YYYY'))'},[availability]={'na'}>} [sales]),[client])>0, [client]),[client]))

[ioannagr]

my problem is how to implement this  if check in the above expression @QFabian 

[QFabian]

Ok, sorry about that, you can use and, to put more rules inside your if... is that?