0 Replies Latest reply: Jul 1, 2015 3:19 PM by Matt Mohon RSS

    Ranking in KPI table not working

    Matt Mohon

      I have a rank function that works great in a straight table.  I want to use the same thing in a simple kpi table and I cant figure out how to get it to work. Can anyone tell me what I'm missing?

       

      I have 2 trim variables to take off outliers, vLTrim = .05, vUTrim = .95

      I have 1  set analysis variable, vComparison_Set_Analysis = '{$ <[group]=>}'

       

      rank(TOTAL

      SUM($(vComparison_Set_Analysis)

      if([revenue] >= aggr(NODISTINCT fractile( $(vComparison_Set_Analysis) [revenue], vLTrim),[fy_end]) and

         [revenue] <= aggr(NODISTINCT fractile($(vComparison_Set_Analysis) [revenue] , vUTrim),[fy_end]),

         [revenue])

               ),0,2)