condition on max inside sum function

[#1]

Hello, If I want to take the count of candidateid when weekingdate is maximum and status='active', then how can I write the set analysis function for this

Thanks

Arif

[MayilVahanan]

HI

Try like this

=Count({<Status = {'active'},Weekingdate ={'$(=max(Weekingday))'}>}Candidateid)

but when weekingdate is maximum ? represents sunday or something else??

bit confuse. can you explain it?

Hope it helps