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)