cancel
Showing results for 
Search instead for 
Did you mean: 

Max Value

ZahibSidiq
Level 4
hello, 

The fastest way to find the highest number or max value, lets say between three number. Any help is appreciated.  
BR

Zahib
10 REPLIES 10

Hello @BernadetteStroe

You can also use the 'Filter collection' action in the BDO 'Utillity - Collection Manipulation'.
If you use a filter like "[Age] = MAX(Age)" then you will get the row(s) with the maximum value for age and if you use "[Age] = MIN(Age)" then you will get the minimum one. 

Hope it helps.

Regards.
Lars

------------------------------
Lars Vinding
Faglig koordinator
Kolding Kommune
Europe/Copenhagen
------------------------------