sum of max date

[QSense]

Hello ,

I have a problem while summing an expression includes max date field.

My expression below.

= sum( if(Num(interval(max(Timestamp(BT))-max(Timestamp(AT)),'d'),'#.##')<=7,1,0) )

In shortly I can explain my problem; I have an ID and according to this ID I get 3 records ,

I wanna get max BT date record and then according to number coming from interval ı will classify the record such as 0 and 1

and then at last ı wanna sum of this classified numbers.

I m looking forwards solutions

regards

[MayilVahanan]

Hi

May be try like this

Sum(If(Max(Aggr( Timestamp( BT ) - Timestamp( AT ) , Id))<=7, 1, 0))