2 Replies Latest reply on Jul 17, 2014 12:56 PM by photowyzard

    Trailing Grand Summary: Finding the Largest Number

    photowyzard

      Title

      Trailing Grand Summary: Finding the Largest Number

      Post

           I am brain blocked on how to do the following:

           Lets say we have 25 Records. (Number of records doesn't matter)

           Record size increases over time.

           We have a Field called DISTANCE.  Distance in each record only increases in number by random amounts.

           In the Grand Summary, we have a field called Total Distance. 

           There could be 40 or 50 records, with additional records being added on an ongoing basis, but the only number that I want to capture is the record that has the highest number. 

           How would you suggust I go about doing that?

           Example for futher clarity

           Record #1, Distance 100

           Record #2,  Distance 200

           Record #3,  Distance 150

           In my summary report, I just want the value for Record #2.... 200, becuase that is the largest number.

           When Record #4 is recorded and the Distance value is 400, I want my report to capture the highest number, which is 400.

           Thanks in advance.