topic Re: Percentile Calculation Issue in App Development

Percentile Calculation Issue

SudharshanK — Wed, 28 Jun 2023 14:19:50 GMT

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.

Re: Percentile Calculation Issue

Chanty4u — Wed, 28 Jun 2023 15:10:59 GMT

Try this

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

Re: Percentile Calculation Issue

SudharshanK — Wed, 28 Jun 2023 15:14:44 GMT

I tried this but its still giving the same result