Text Box Calculation

[tmumaw]

Morning everyone,

I have a text object which does a calculation, and below the text object I have a straight table which ranks the average number of days from low to high.  The ranking in the straight table starts at 2 - 10.  The text object is the number 1.  For some reason it's coming up negative, and yes there is an negative sign before the average so it can sort in the correct order.  I need to get rid of the negative sign.  Here is the calculation I'm using.

=' Top - ' &FirstSortedValue(distinct Recruit_Mgr, -Aggr(-avg({<Closed = {1}>}Age),Recruit_Mgr)) & ' - '& Max(Num(aggr(-avg({<Closed = {1}>}Age) ,[Recruit_Mgr] ),'#,##0') )

[tmumaw · Accepted solution]

Figured it out. Should have been a min not a max.

=' Top - ' &FirstSortedValue(distinct Recruit_Mgr, -Aggr(-avg({<Closed = {1}>}Age),Recruit_Mgr)) & ' - '& Min(Num(aggr(avg({<Closed = {1}>}Age) ,[Recruit_Mgr] ),'#,##0'))