Returning the highest value from a list

[#1]

Hi, I know this might be very simple for many of you but I'm struggling to find the solution.

I want to return the highest value from a set of results, in this case Ans_Minutes that holds 28 results.

I have been trying Max and FirstSortedValue but getting nowhere!

I have added the qvw below - I'm trying to populate the two Text Objects in the file

One with the Highest Value found in the Table

The other adding the 3 highest values that are illustrated in the Focus e.g. 193.0, 123.2 & 101.7  = 417.9

Hope this makes more sense.

Thanks

Rob

[whiteline · Accepted solution]

Maximum:

=num(Max({$<Response_Level_2={*}>}aggr(sum (Ans_Minutes), Response_Level_2, Ans_Text))/60,'##0')

Three highest values:

=num(rangesum(

              Max({$<Response_Level_2={*}>}aggr(sum (Ans_Minutes), Response_Level_2, Ans_Text), 1),

              Max({$<Response_Level_2={*}>}aggr(sum (Ans_Minutes), Response_Level_2, Ans_Text), 2),

              Max({$<Response_Level_2={*}>}aggr(sum (Ans_Minutes), Response_Level_2, Ans_Text), 3))/60,'##0')

[#3]

Excellent, thank you again for your help.

Rob