Jump to content

Sub-summary (trailing) Returns Value of Last Record


millrene
 Share

This topic is 5597 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello, I am new to FileMaker and I am trying to create summary report. I have a donations database. I have a Donation table that tracks Amount, Date, donationID, etc. I have Cause table that has LocationID, Project_CodeId and CauseId that the donation was given towards.

I have created a relationship between these two tables based on Primary Cause Id and Foreign Cause ID in the Donation table.

I have a summary field called Amt_Sum that summaries the Total of the Amt field.

In my report, which is based on the Cause Table, I have it sorted by Location Number and then Project Code. I have the Amt_Sum field (which comes from the relationship between Cause and Donations table) in the body and it displays the toatal amt of donations given for a particualr Project Code.

I have a sub-summary (trailing) part that I want to a total of all donations for that location number. I have the Amt_Sum field again, but it only shows the value of the last project code of that location.

I have spent way too many days trying to figure out what I have done wrong. I hope somebody with more experience can see my error. I hope I have given enough detail to understand what I am trying to do. Thanks in advance for any help.

RM

Link to comment
Share on other sites

Amt_Sum should be a field in the Cause (parent) table. It should be a calculated field, not a summary field, and the calc is Sum(related::amount).

Then make a summary field in Cause that is Total of Amt_Sum. Place this field in your sub-summary part and you're done.

Link to comment
Share on other sites

Fitch,

Thank you so much! That was the answer I was searching for! I had tried something along those lines, but I kept spinning in circles and wasn't getting anywhere, but frustrated. I love FileMaker. It is a cool program and I am looking forward to learning more.

RM

Link to comment
Share on other sites

This topic is 5597 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.