Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
And yes, please close the thread now by marking correct/helpful answers