2 Replies Latest reply: Oct 28, 2013 6:50 PM by James Parker RSS

    Using Fractile with a set modifier

      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?