Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In a text field I want to display the name of a value with the highest count.
So far I have this
=MaxString(aggr(Count({1<[Billable_Status] = {Billable}>}Practice)Practice))
This returns back the highest count of billable employees in a practice, but I want it to display the name of the practice not the count.
Thanks.
Try like:
=FirstSortedValue( YourNamefield, - aggr(Count({1<[Billable_Status] = {'Billable'}>}Practice), Practice) )
Try like:
=FirstSortedValue( YourNamefield, - aggr(Count({1<[Billable_Status] = {'Billable'}>}Practice), Practice) )
This works!
Thanks a lot for the help