AnsweredAssumed Answered

How do I find the maximum number in a set of subtotals?

Question asked by billrollins on Aug 28, 2010
Latest reply on Aug 30, 2010 by philmodjunk

Title

How do I find the maximum number in a set of subtotals?

Post

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?

Example Layout:

LCD Projector

DateQuantity

9/15

9/23

9/33

9/41

9/51

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.

Outcomes