Report Totals problem - new user
I'm a recent Filemaker user, having transferred a membership application from Lotus Approach. I'm having difficulty in adding a grand total to a subscription report. I think the problem is in the structure I've created and maybe I have to change that to solve the problem.
The report is selected and sorted records from the Person table, with Date and SubShare from the Payments table. I want a grand total of the subscriptions that appear on the report for the current year (usually about 1100). My attempts so far will only produce a total for a Person, drawn from a number of years. In case it is not clear from the relationship table, some of the figures are drawn twice from the Payments table.
I would be grateful for any comments or advice.