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

[Scott Walker]

How about:

a=MAX(n)

Finds maximum value of field "n" on output.


Regards,
Scott Walker



-----Original Message-----
From: Filepro-list
[mailto:filepro-list-bounces+scottwalker=ramsystemscorp.com at lists.celestial.
com] On Behalf Of Bob Simcoe via Filepro-list
Sent: Wednesday, August 22, 2018 12:34 PM
To: Michael Thompson <Michael.Thompson at pcquest.net>
Cc: filepro-list at lists.celestial.com
Subject: RE: Question - find highest number in a field out all the records

 
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 
> bounces+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
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list