Percentile Calculation Issue

[SudharshanK]

Hi,

I am unable to compute the percentile of account balance correctly. I used the formula Fractile (Account Balance, .7) in order to get the 70 percentile but its showing up the same values as the account balances instead.  

[Chanty4u]

Try this

Fractile(Aggr(Num(Account Balance), Account Balance), 0.7)

[SudharshanK]

I tried this but its still giving the same result