How do I find the maximum number in a set of subtotals?
I've been stuck on this for quite awhile. I have AV Gear, Quantity, and Date it will be used at a meeting. The meeting lasts 5 days. I have a layout that shows me each type of Gear, then the dates that Gear is being used and the Total Quantity for each date. How do I add a summary field that then gives me the highest number needed over those five days?
Maximum number 5
FileMaker won't let me make a Summary Field of a Summary Field and I've tried everything else I can think of.