AnsweredAssumed Answered

Multiple summary fields in final report

Question asked by MaryAnn on Jun 4, 2010
Latest reply on Jun 8, 2010 by MaryAnn

Title

Multiple summary fields in final report

Post

I am using FMP6 with Windows 7.  I am trying to track expenditures by requisition. I have two files, the requisiton file that contains the requisition information such as company, quantity, description, and total amount approved.  The second file is for purchases against the requisitions, with a record for each purchase.  I need to creat a report that shows all requisitions, company name, requisition number, amount approved, total spent and balance. My total spent field is a summary field for "total" based on purchase amount, with running total checked.    I have a sub summary sorted on the requisition number, but the amount spent and the balance for that requisition are not correct, but appears to be a running total from the previous gorup of records above it in the report.  How do I set up the report to show a sub total spent and balance for each requisition and a grand total for everything spent on all requisitions?

Outcomes