Forum Discussion

MattHardy1's avatar
MattHardy1
Qrew Trainee
3 years ago

Find Highest Field Value

I have a table with an Invoice # field (numeric) - how can I find the highest Invoice # using a formula?

Thanks

------------------------------
Matt Hardy
------------------------------
Relationships

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    The easiest way to do this is to make a helper table called Max Invoice with one and only one record in it. The single record will have a Record ID of 1.

    The relationship back to your details table and on the reference side make a formula field called Link to Max invoice with a formula of 1.

    The summary maximum on that relationship and then look up the maximum invoice number back down to invoices.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • MattHardy1's avatar
      MattHardy1
      Qrew Trainee
      3 years ago
      So simple. I was over complicating this. Thank you

      ------------------------------
      Matt Hardy
      ------------------------------