Grand total from calculated summary

[autdesign]

I am working on an Accounts Receivable Invoice Edit report. The detail section includes listings of General Ledger account numbers that are hit by each AR Invoice. The summary lines I need to report don't simply summarize the detail activity. That is the first step, I use a summary field to get the total Debits for that account, and another to get the total Credits for that account. So far so good.

Some of the GL accounts will have both Debits and Credit summaries, but we only want to report the net activity. I have put a calculated field on the Sub-Summary line to calculated whether the net activity will return a debit balance. (There is also a Credit formula similar to this) The Debit formula is: If(GetSummary(s_debit, GLBU_ACCOUNT_NUMBER) - GetSummary(s_credit,GLBU_ACCOUNT_NUMBER) >= 0, GetSummary(s_debit, GLBU_ACCOUNT_NUMBER) - GetSummary(s_credit,GLBU_ACCOUNT_NUMBER), "")

My problem is how do I summarize the result returned in this calculation? Since it is a caculation, it says this amount belongs to each line, so when I try to summarize, my totals are way high. For example, Debits 500, Credits 200 and there were 5 lines for this Account Number. The summary is returning 1,500, or 300 x 5.

Any ideas?

[ February 22, 2002, 07:50 AM: Message edited by: autdesign ]

[LiveOak]

Create a summary field that is a summary of "debit forumul".

-bd

[autdesign]

LiveOak,

Thank you for the idea, but I have already tried that and it is unsuccessful. The issue being, the Summary field tries to summarize the calculated field as if it is on every line in the detail.

Again, if the calculated difference was 300 and the detail has 5 lines, it is returning 1,500, and not just the 300.

I can email example for clarification if someone needs.

[ February 22, 2002, 12:17 PM: Message edited by: autdesign ]