Finding highest value in a portal

[lrcarey]

Hello all,

I'm trying to figure out how I can get a calculating field to look at the rows in a portal and compare them to find the highest value in a given field. Then the calculating field should display that highest value. To further complicate it, I only want to include certain rows - the rows to look at are marked with a "1" and the rows to ignore are marked with a "0".

(The problem I am trying to solve involves looking at which activity completed by a given person within specific dates involved the most number of hours - if that helps!) - I'm stumped!

Thanks in advance,

Leah

[falkaholic]

The Max(Field) function should do the first part.

Max(ThePortalRelation::TheField)

As for the 1 or 0 filter, you'll want to make 2 relations. One for records with 1 and one with 0 use and calculation field as the key.