aggr function

sayalip — Thu, 06 Feb 2020 16:54:08 GMT

HI Everyone,

it would be great if you suggest on below-

i have below data

flag value says yes or no for employee who is coming for event. (if employee is coming for event then flag yes else no)

date is updated entry for employee if employee changes mind for attending event.

i want final list of employee who are coming for event.

Re: aggr function

sunny_talwar — Thu, 06 Feb 2020 18:15:46 GMT

Try this

=-Sum(Aggr(FirstSortedValue(flag, -date) = 'Y', [Emp id]))

sayalip — Thu, 06 Feb 2020 18:46:10 GMT

thank you so much it works.