Best 3 Average

[Anonymous]

Hi,

I'm struggling to get a 'best 3 average' formula to calculate and display for all values.  I was able to get the total average displaying for all but not the best 3 average.  Image shows example data and the desired output.  Any help would be greatly appreciated.

[Anonymous]

Hi ,

Use the below code in expression

=SUM(TOTAL<Year>(aggr((if(Rank(SUM(Number),4)<=3,sum(Number))),Year,Name)))/3

Thanks,

Venkata Sreekanth

[shiveshsingh]

Hi

i have already attached the app for our reference.

any ways use this expression

sum(TOTAL<Year>(aggr((if(Rank(sum(Number),4)<=3,sum(Number))),Year,Name)))/3

[shiveshsingh]

And yes, please close the thread now by marking correct/helpful answers