Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mathblaster

    field cannot be summarized

    It's not that I am not providing the necessary information, I would gladly share all of the information. I guess I don't quite understand what it is you need to see in order to help. I am real new at this, so I appologize for my lack of understanding. -Sorry you gave up on this. Anyone...
  2. mathblaster

    field cannot be summarized

    estimate was not an attempt to implement your earlier suggestion? estimate is the percentage adjustment to the prior years actuals. Group #1 Name: @fund Group #2 Name: @DEPT Group #3 Name: @type Group #4 Name: @CRECode When I modified the estimate variable with your formula, it changed the...
  3. mathblaster

    field cannot be summarized

    Sorry. Guess I missed a few answers, was a long day. (PH) 2006 (GH1a) @estTotal whileprintingrecords; //Sum ({@YTDAmount}, {@fund}) {@Yr1Total} (GH2) @reset whileprintingrecords; numbervar estimate:=0 (GH3) @estimate Sum ({@YTDAmount}, {@Type})*{@factor2} (details)@estimate Sum...
  4. mathblaster

    field cannot be summarized

    Sorry- Report Structure looks like this: Year 2004 2005 2006 2007 2008 (GH1a) 100.00 250.00 515.00 XXXXX XXXX Revenue (GH3) 100 125.00 137.50 150 180.00 (GH3) 1,000 1100 1200 1300 1300.00 (GF2) 1200.00 1475.00 XXXXX XXXXX XXXXX Expense (GH3) 900.00 910.00 1000.00 1100.00 1100.00 (GH3)...
  5. mathblaster

    field cannot be summarized

    If I understand this right, it is actually summarizing the prior year's data with this command Sum ({@YTDAmount}, {@Type})*{@factor2}. The YTDAmount is in reference to 2005 actuals. When I try to build a running total, there are no tables or fields that match up to the 2006 calculated data...
  6. mathblaster

    field cannot be summarized

    Hello, I'm unable to do something that should be straight forward... I'm using CR 9 with SQL. In my report I have 5 columns (2004, 2005, 2006, 2007, 2008). 04 and 05 are actual YTDAmount numbers from SQL data base. 06, 07, 08 are based on a formula (05*factor of %increase). In the group...
  7. mathblaster

    total or sum calculated columns

    After re-reading my post, i guess i was not real clear. in each section i have a beginging total, total revenue, and total expense. I am trying to sub-total those three sections in multiple fields per column. Maybe i am still not clear. 8,114.80 begining number 112,183.95 revenue subtotal...
  8. mathblaster

    total or sum calculated columns

    CR 19 ODBC [RDO] CONNECTION SQL DATABASE i have a report that is 4 columns. columns 2-4 are based off of column 1. i.e. column 2 is a percentage factor of 1. I can sum the y-t-d total for column 1 in GF2, but can't get grand totals from the sub totals in columns 2-4. example: 2004...
  9. mathblaster

    PERCENTAGE FORMULA

    I have not figured out how to sum the calculated columns, how did you do that?

Part and Inventory Search

Back
Top