Question - find highest number in a field out all the records

[Bob Simcoe]

I forgot how to best display processing lines, but this was short.
Field 1 holds the values
Index A is built on Field 1
Input Processing
Add Records mode

 1 
                    If:
              Then: end 
-------------------------------------------------
  2
@wlf1        If:
               Then: aa(4,.0,g) = "9999"
-------------------------------------------------
  3                 If:
                Then: lookup -  k=(aa)  i=a -el
-------------------------------------------------
  4                 If:
                 Then: 1 = -(1)  ;  display  ;  end
-------------------------------------------------
Thank you

Bob Simcoe

> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+bob=midcityoffice.com at lists.celestial.com] On Behalf Of Michael
> Thompson via Filepro-list
> Sent: Wednesday, August 22, 2018 11:54 AM
> To: filepro-list at lists.celestial.com
> Subject: Question - find highest number in a field out all the records
> 
>  I have a question. How do I get the greatest number in a certain field out of
> all the records.
> Example: I want pull the 4999 out of all the records to display in field or
> report.
> 
> rec#   -   Field Value
> 1.      -       1999
> 2.      -       4999
> 3.      -       3999
> 4.      -       2999
> 5.      -       4999
> 6       -       3999
> 
> Thanks,
> 
> 
> 
> Michael Thompson, Senior Network Analyst
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-
> list/attachments/20180822/6a1921b2/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list