If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculations "between" groups sums
I'm using groups for a number of reports. Now I need to complement my reports
with more sums between the various groupings but is that possible? As an example we could say that I have something looking like below where I want to solve the Gross Profit "problem"; Account Account name $ 3010 Software Sales 1000 3020 Hardware Sales 2000 Sum Sales 3000 4010 CostGoodsSold 2000 Sum CGS 2000 Gross Profit 1000 (This is an example o a sum i would like how to create and present "within" the various groups) 5011 Rent of premises 500 5020 Elictricity 50 Sum Other Expenses and so on.... Thank you for your help / Bell |
#2
|
|||
|
|||
Bell
You need to add another field (like Category) to your table that "groups" the 3000 accts with the 4000 accts for a final calculation. Use a term that makes sense... to your system. Example... Acct Type Amt Category 3010 SoftwareSales 1000 SalesProfit 3020 HardwareSales 2000 SalesProfit 4010 CostOfGoods -2000 SalesProfit 5011 Rent of premises -500 OverHead 5020 Electricity -50 OverHead Now you can create a higher break on SalesProfit so that = Sum(Amt) would yield 1000 in the footer of the SalesProfit group. Also, it would make it much easier if you expressed Costs as negative, and Income as positive. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Bell" wrote in message ... I'm using groups for a number of reports. Now I need to complement my reports with more sums between the various groupings but is that possible? As an example we could say that I have something looking like below where I want to solve the Gross Profit "problem"; Account Account name $ 3010 Software Sales 1000 3020 Hardware Sales 2000 Sum Sales 3000 4010 CostGoodsSold 2000 Sum CGS 2000 Gross Profit 1000 (This is an example o a sum i would like how to create and present "within" the various groups) 5011 Rent of premises 500 5020 Elictricity 50 Sum Other Expenses and so on.... Thank you for your help / Bell |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I get the sum from a column and display the sum? | jon | General Discussion | 9 | March 11th, 2005 05:22 PM |
Collapsed "from" groups in office 2003 | krell | General Discussions | 0 | November 11th, 2004 09:23 AM |
disable Show in Groups | Deckard | General Discussion | 1 | September 1st, 2004 01:49 PM |
OE6 to Outlook 2000 "Lost Contacts in Groups" | jstubb | Outlook Express | 2 | June 24th, 2004 05:27 AM |
Disabling Show in Groups on all folders | andreas gammel | General Discussion | 0 | June 8th, 2004 02:21 PM |