help - aggr function

[#1]

Dear All,

I need to calculate the sum(amount) only ID's having selected date - max(date) is less than or equal to 556.

PFA.

thanks in advance

[swuehl]

Try

=sum(aggr(if(Today()-max(DMonthEnd)<=556, sum(Amount)),ID))

this will return a higher amount than given by you, since also IDs 7,8,10 are fulfilling the requirement.

Hope this helps,

Stefan

edit:

This set expression should also work:

=sum({<ID = {"=today()-max(DMonthEnd) <=556" }>}Amount)

[sathishkumar_go]

HI Gopi,  Please find the attachments. I hope this will helpful for you.  Regards Sathish

[#4]

thank you swuehl,sathish,

i tried the delow expression, its working fine.

=sum({<ID={"=today()-max(DMonthEnd)<=555"}>}Amount)