take the max of the week

[Honki]

Hello!

this function works.

sum(if(Aggr(Count(C),P)>1  ,1))

But, I want to calculate this below for week= max(week). I did this:

sum(if(Aggr(Count(C),P)>1  and week=max(week) ,1))  but it doesn't work.

I need help, please, please!!!!!!!!!!

[vinieme12 · Accepted solution]

As below

=sum(if(Aggr(Count({<week={"$(=max(week))"}>}C),P)>1 ,1))