LoriE

Calculation field to return the greatest number from another field

Discussion created by LoriE on Nov 29, 2016
Latest reply on Nov 29, 2016 by LoriE

I have a script that sorts the records in the found set

 

I want my meeting # field to look at another field and return the highest number in that field so when I perform the script the most current meeting number will show.

 

As it is now it always shows meeting #1 (probably because my report has a sub summary section for "old" business and "new" business. The field I

have circled below (meeting #) always shows meeting 1 when I actually want it to show latest Meeting 3. This field is in the title header.

 

Not sure if anyone will understand what I am getting at but will try anyway. I have played with the sort order, but no luck.

 

Capture.JPG

Outcomes