High value for the day

[sgonzo]

I'm new to Filemaker, trying to make a 30 day evaluation.

I have many records each day, with Date, Subject, and Amount.

For each date, I want to extract just the Highest Amount record of each subject for a report.

So each subject with have one line for each day, which is the record where Amount is the Maximum on that date for that subject.

I can see how Filemaker does simple things, but the logic of how to do this escapes me. Any help or references to learn more would be appreciated.

[-Queue-]

You can create a summary field defined to be the Maximum of Amount and add this to a Subsummary part by Date on a layout. Sort your found records by Date. When you preview or print this sorted report, the summary field should display the maximum Amount for a particular Date.

If you only want the summary and no individual records to be displayed, remove the Body part from your layout by selecting it in Layout Mode and pressing Delete.

[sgonzo]

Thank you so much. I've got that working.

Can I ask one more advancement? Can I pull other fields from that same record that the Maximum of Amount came from?

Date Subject Maximum of Amount OtherFieldFromSameRecord as that Maximimum?

[-Queue-]

You can create a self-relationship based on Date, sorted by Amount descending, so that selfrelationship::Amount refers to the largest Amount for that day. selfrelationship::Subject would then refer to that same record's Subject.

[sgonzo]

Thanks again. Works great. I think I'm starting to get the logic of this program