Simple Summary Calculation issue

Discussion created by jayankurian on Jun 26, 2018
Latest reply on Jun 26, 2018 by jayankurian

Hi all.


A simple calculation problem.

File attached.


FM Version: 16

Tables 1: (Primary Table holds Annual Membership Fee)

Table 2: (Secondary – MANY TABLE – holds Members multiple payment data)

Relationship: Member ID with Member ID

What I am trying to do is:

Generate a report which gives me the Total Payment by each member and the Balance Due on each member.

Also want to print out a report Balance Due = 0

Another one with Balance Due list > 0

Somehow my calculation is not giving the right Balance Due amount.

Also the Grand Total of the Membership Fee


Thank you