AnsweredAssumed Answered

Related field to summary of record set

Question asked by smparodi on Nov 26, 2017
Latest reply on Nov 26, 2017 by smparodi

FMPA 14. I have the table Master and the table Production, both related through field CODVAR. The table Production has several data into the following fields: CODVAR, TEST, WEEK, STEMS; I can correctly summarize some of these data with the summary built in functions of FMP (eg: Max(STEMS), Sum(STEMS)). My problem is I need a summarized field that shows me the content of field WEEK which corresponds with summary Max(STEMS) for each set of records of same TEST and same CODVAR.

 

CODVARTESTWEEKSTEMS
A1T1110
A1T1215
A1T1330
A1T148
Max

3

30
Sum63

 

Any help would be greatly appreciated. Thanks so much in advance.

Outcomes