average fractile

[#1]

Hello

I am using the fractile function to find out my 95th percentile and then using that I am average the top 95 percent,

Using the function. =Avg(Aggr(If(Counter < Fractile(Total  <MetricName> Counter,0.95),Counter),MetricName,ID)).

this function returns 832 as my 95th percentile

but the avg displayed in the chart is 266 which is not correct I need 261.

but using the expression =Avg(Aggr(If(Counter < 832,Counter),MetricName,ID)) gives me the correct result, but as a function as whole does evaluate

Please help, attached the excel as well