Trying to get a total on a subsummary report
I am having a hard time with this report!
It's a itemized statement of accounts for past due invoices sorted by client and invoice ids. It's sorting portals and does a fine job in that respect. The problem is trying to total these portals. I can't use the final column (new balance) because the first row is picked up instead of the last so I made a subtotal field which calculates the final balance. That works fine.
I'm trying to get a total of the subtotals and that is what is not working. I have a subsummary part at the end with the Total Statement Amount field that does not show anything. At first this field was sum(subtotal) and I got nothing. Next I tried making the subtotal a subsummary part and that didn't work. I tried various combos with the just the field subtotal and it is still blank.
Can anyone help me? This is the very last thing I need to do on this database.
FMP 10 Advanced Mac 10.6.2
I finally solved it! The total field needed to be a summary field and I was using a calculation.