Fractile function

[#1]

Hello I have this expression

num(fractile(sum({<[Indicator ID]={236}>} Numerator/Denominator) /1000,'0.25),'##.00 %')

but I dont know why it is not working and I have made four others like it each with the previous column removed and the fractile changed for example 0.25 becomes 0.5 then 0.75 and sp on can anyone either explain this or help me solve this.

Thanks for any help

[sunny_talwar]

fractile and sum are both aggregation functions and cannot be combined without an Aggr() function. May be provide a sample with expected output and we might be able to help you better

[Clever_Anjos]

I can see a small apostrofe there just before 0.25, maybe this plus stalwar1‌ recommendation

num(fractile(sum({<[Indicator ID]={236}>} Numerator/Denominator) /1000,'0.25),'##.00 %')