Confiforms Table View Merger to display max value

unknown

With Table view Merger, I am able to get the total count of elements, using the expression ([count]).

 

Now I am trying to get the MAXIMUM value instead. 

 

So far I've seen the MAX function, but it only takes 2 elements and I can't see a way to apply this function to the entire group. 

 

Thanks in advance

Alex Medved _ConfiForms_

Hi

You are saying you want to display "MAXIMUM" value... sort it by this field and get the "view" to return only the 1 row.. which will be your maximum value for the field

MAX function you are referring to is not relevant here as it is applied on the row, not across the rows. And of course you can have more arguments.. actually more functions embedded if you want to have more arguments

MAX(val1, MAX(val2, val2))

But again, this is for formulas that are calculated per row / record

Alex