FirstSortedValue Expression

[tmumaw]

Does anyone see anything wrong with this expression?

=FirstSortedValue(distinct(SF_Job, - Aggr(count(distinct(Requisition),SF_Job))

I'm trying to use it in a text box.

Thanks

[Anil_Babu_Samineni · Accepted solution]

May be wrongly placed the parenthesis. Perhaps this?

=FirstSortedValue(distinct SF_Job, -Aggr(count(distinct Requisition),SF_Job))

[tmumaw]

I sent you a sample spreadsheet from another post.  You can ignore it. 

[tmumaw]

How about this one?

FirstSortedValue(distinct SF_Job, -Aggr(sum([Number of Openings]),SF_Job & ' - '& Max(aggr(Sum([Number of Openings])),[SF_Job]))

Thanks

[sunny_talwar · Accepted solution]

Try this... again issues related to the placement of parenthesis

FirstSortedValue(DISTINCT SF_Job, -Aggr(Sum([Number of Openings]), SF_Job))
& ' - '&
Max(Aggr(Sum([Number of Openings]), [SF_Job]))

[tmumaw]

Yep.  Found it about 20 minutes ago and I haven't had a chance go get back here and post as solved.  Thanks.