2 Replies Latest reply on Nov 29, 2016 2:19 PM by LoriE

    Calculation field to return the greatest number from another field


      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.