I am using Filemaker Pro 5.5v2 on a Mac with OS 10.2.2. I have a report that I can generate with no problem at all. The issue is that there is a field in the report associated with each record in the database called number of students. The number is drawn from a related file.
I set up a field in the main database called sumofstudents. This is a calculation field that looks like this under define fields:
Now, the challenge is getting this to appear on the report. This field only pulls a number from the first record in the found set instead of all the records in a found set. So, if I have a found set of 4 records with values of:
The only number that will appear in the sumofstudents field is the first number, 28. I need a sum of ALL the values in the report, which in this example should be 92, not 28.
I have tried using different footer types in the layout, and every trick that I can think of and I still can't get this very basic function to work.