1

Find Highest Number

This must be simple, but I need some help.  

How can you display the highest number in field?  

Example:  I have 1000 Records with 1000 different numbers.

I'd like to show the highest number and then add 1.

3 replies

null
    • Nick
    • 6 yrs ago
    • Reported - view

    From the manual:

    ...selecting records is useful in many situations, one common case is to calculate the next Invoice ID.

    'Invoice ID' := max((select Invoices).'Invoice ID') + 1

    • danlap333
    • 6 yrs ago
    • Reported - view

    I'm not sure if I explained correctly.

     

    I have values in all the records and some are multiples of the same number.   For example, I have the number "68" seven times, "79" three times, "80" 1 one time, etc.      

    Out of these records, let's say the highest value is "106".  I would like to show this max value "106" no matter what record I am looking at.

    • Nick
    • 6 yrs ago
    • Reported - view

    Formula field:

    max((select TableName).FieldName)

Login to reply

Content aside

  • 1 Likes
  • 6 yrs agoLast active
  • 3Replies
  • 1508Views