AnsweredAssumed Answered

Sum multiple fields from multiple records

Question asked by carco on Dec 1, 2017
Latest reply on Dec 13, 2017 by carco

Hello! Im new with FM and I´m having some trouble making a summary report. I have a table with ca. 2000 records and 21 fields: student  name1_1 name1_2 ... name4_4 plus four date fields. I have to count how many times a name appears along all 16 fields per each year found in the four date fields. It sounds like an easy task but I havent been able to make it. I have tried "count of name1_1", etc, but I think it doesn´t bring much. Any help will be highly appreciated.

Outcomes