AnsweredAssumed Answered

Calculation using a summary field

Question asked by mdallie on Aug 5, 2018
Latest reply on Aug 6, 2018 by mdallie

(Using Filemaker Pro 16)

 

I have a transactions file that can have multiple entries for each address (street #).  I am printing out a sort of invoice that lists each transaction that has a sub-summary section of the report with a summary field (Total Due) that totals the transactions up.

 

I then list Amount due prior to (date):, and Amount due after (date).  The amount due after (date) is a calculated field where the calculation is simply Total Due + 25 (i.e., $25 late charge).

 

The report layout in the sub-summary section of the layout is attached along with how it looks when I am out of layout in preview mode.

 

The amount that is due after September 1, should be $290 + 25 = $315.  The number coming out is twice that.  I should add that for the next address, the Total Due is also $290 (coincidentally) and it also shows the amount due after due date as $630.  For the third address the Amount Due priot to September 1, is $25, but the amount due comes out to $630 again (should be $50, $25 due + $25 late charge).

 

My calculation field for the "Total Due after Due Date" is also attached.

 

 

Any help is sincerely appreciated.

Outcomes