Using Fractile with a set modifier

[#1]

Hi all,

I'm using the following expression to work out the upper quartile of my selection:

=Fractile(TOTAL Aggr(Sum(Actual_Utilized_Amount),County), 0.75)

If I select a county, I still want to calculate the upper quartile for all counties, rather than just the selected county. I've tried using a set modifier in my expression but it does not work:

= Fractile({<County = >} TOTAL Aggr(Sum( Actual_Utilized_Amount),County),0.75)

or

= Fractile(TOTAL Aggr(Sum({<County = >} Actual_Utilized_Amount),County),0.75)

What am I doing wrong?

[swuehl · Accepted solution]

Have you tried

= Fractile({<County= >} TOTAL Aggr(Sum({<County = >} Actual_Utilized_Amount),County),0.75)

[#3]

That did the trick nicely. Thank you