AnsweredAssumed Answered

Report Totals problem - new user

Question asked by PhilBiker on Sep 2, 2012
Latest reply on Sep 8, 2012 by PhilBiker

Title

Report Totals problem - new user

Post

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.

Relationships.png

Outcomes