AnsweredAssumed Answered

scripting question

Question asked by rbogdanoff on Feb 9, 2013
Latest reply on Feb 10, 2013 by rbogdanoff

New at Filemaker scripting syntax. I have a table called DONORS, and a related table of all their donations as individual records called DONATION, linked by a key field donorID. I can get the sum of all donations with a calculation field in the DONORS table: Sum (DONATION::amount)

 

How (and where) do I create a calculation field to show the sum of all donations for each donor for a particular year. I tried creating a field in the DONORS table and tried this calculation which did not work:

 

If (Year (DONATION::gift date) = 2012);

Sum (DONATION::amount); 0)

 

Thanks in advance for any help.

Outcomes