Summary of Summary of Summary of Totals....

Summary of Summary of Summary of Totals....

Post by Alex Solan » Wed, 26 May 1999 04:00:00

Hello all....I appreciate any input since I am considering taking a butter
knife to my wrist. J/K.  What I am trying to do is get a Grand Summary of
all outstanding amount whether they are zero balances or not....currently
the only way I see anything is having a report with ALL invoices + payments
(under their columns) listed which gives me a total per customer # + name
for invoices (Sum Debit) and payments (Sum Credit).  This way I get it per
customer no problem, if I add the field "Balance" it gives me a total of all
invoices of all customer together being a FULL total no subtractions
splitting only where the customer changes but still it's the same
total...example   cust.A blah blah blah Total = 322,089.21.....cust. B blah
blah blah Total = 322,089.21, etc..  Now if I remove the body to only get
the Sub-Summary without listing all payments and invoices and put "Balance"
I get the same effect.

I have several fields that intertwine..
Amount, Shipping Charge, Credit, Balance=Sum Debit-Sum Credit,
Total....which is.... Sum(Amount)+Shipping Charge, Sum Debit...which
is....Summary=Total of Totals, Sum Credit...which is....Summary=Total of
Credit...which is the payments.

Would appreciate any input if any other information is needed..don't
hesitate to ask.  Thanx for any help.


1. Summary fields or Summary table?

First posting to the group - thanks to everyone for all the great

Is there any advantage either way between having a large number of
summary fields (20 or more) in a table, as opposed to creating a
related table and using sum(related field)?

I wish FM would let me do summary queries on the fly, without defining
a field or table first.


2. External data/ODBC problem in Excel

3. How to make calculations based on several summary fields included in a sub-summary part

4. sp_help error - Is this a bug ?

5. Summary of a Summary?

6. Database freeware from GARBO added to JUMBO ! &


8. DNS-Less connection

9. Reports & Summary Totals

10. Summary Totals

11. Summary / Totals across records

12. Forcing running total summaries by page?

13. Forcing running total summaries