the aggregate functions apply differently that you would expect when used on fields/records in same table••
whether displayed in a or not.•
If you need the max over a found set. Try a summary field.
This is confusing as the aggregate functions don't work as you would expect by default. In an Excel spreadsheet, the SUM works on that data right there. But in FMP, it doesn't. It works with related data and other. Just one thing to learn.
Hopefully, they'll fix that counter-intuitiveness in some future version.
As philmodjunk said, a summary field is the way to go.
A summary field is really cool since in a report, for example, the field will give you different (but correct) amounts depending on where you put it. So, you could create a single COUNT summary field. If you put the field in the header, it will give you the count of all the records. But, if you copy and paste that same summary field and put it into a detail band, it will give you the count of just those shown records.
That's pretty cool!