Wanting to sum Consolidation accounts from Businessworks 2011 (1 Viewer)

Repent

Registered User.
Local time
Today, 16:42
Joined
Apr 10, 2008
Messages
108
I am trying to figure out the formula for summing some consolidation accounts from Businessworks Gold 2011 (BWG). I have the developers edition of CR for BWG so I can access the DB for BWG.

The account numbers from BWG "Chart of Accounts" are:
400000.000
419999.000
430000.000

The Table for "GLAccount" has the fields of "GLAccountNumber" and "Description" that show all the account numbers from the Chart of Accounts an a description of what that account number is for. When I drop those fields onto the report, I can see the accounts listed that I want to sum. I don't want to sum the account numbers obviously, rather, the dollar amounts that are listed for those account numbers.

These accounts are consolidation accounts inside BWG and as I understand it, they total several separate accounts to come to a "grand total" for those accounts.
I want to place the sum in the report footer.

How do I create a formula to sum all these values?

TIA;
Chris
 

Repent

Registered User.
Local time
Today, 16:42
Joined
Apr 10, 2008
Messages
108
disregard this question. Another question has taken it's place.

chris
 

Users who are viewing this thread

Top Bottom