Fractile in a calculated field filtering issue

[mmg1984]

I'm trying to calculate the 5 percentile in a calculation as per below:

Fractile({<[Site]=>} Total
aggr(
(Max(DATA_VOLUME)/3600/1024+Max(DATA_VOLUME)/3600/1024*Forecast*IF([Host]='A',(1+Capped_Traffic),1))
/
(max(aggr(Sum(Bandwidth),[Site],[Sector]))*Efficiency*Utilisation)
,[Site])
, 0.05)

My issue is that it works as it should till I filter then it recalculates the percentile for the row that has been filter, I'm filtering by Site, any help will be more than welcome.

[Anil_Babu_Samineni]

Perhaps this?

Fractile({<[Site]=>} Total
aggr(
(Max({<[Site]=>} DATA_VOLUME)/3600/1024+Max{<[Site]=>} DATA_VOLUME)/3600/1024*Forecast*IF([Host]='A',(1+Capped_Traffic),1))
/
(max({<[Site]=>} aggr(Sum({<[Site]=>} Bandwidth),[Site],[Sector]))*Efficiency*Utilisation)
,[Site])
, 0.05)

[mmg1984 · Accepted solution]

Hi,

I just fixed adding  {<[Site]=>} after the aggr

Fractile({<[Site]=>} Total
aggr({<[Site]=>}
(Max(DATA_VOLUME)/3600/1024+Max(DATA_VOLUME)/3600/1024*Forecast*IF([Host]='A',(1+Capped_Traffic),1))
/
(max(aggr(Sum(Bandwidth),[Site],[Sector]))*Efficiency*Utilisation)
,[Site])
, 0.05)