total or sum calculated columns

[mathblaster]

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 2005 2006 2007
Sum of @YTDAmount

I reset each new year, and included whileprintingrecords;
numbervar estimate:=estimate + {@estimate}per year.
I have no sub reports, nor cross-tabs. Is there any formula to write to total or sum the calculated sub totals in columns 2, 3 and 4 seperately by column? I am stuck.

Thanks for any help out there.

 

[synapsevampire]

Assuming that what you're saying is that you wish to sum a formula within a group, try the 3 formula method:

group header:

whileprintingrecords;
numbervar MySum:=0;

Details:

whileprintingrecords;
numbervar MySum:=MySum+{@MyFormula};

group Footer:

whileprintingrecords;
numbervar MySum

-k

 

[mathblaster]

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
-117,904.91 expense subtotal
__________ grand total

does that help. i tried the 3 formula method and i get a wrong number.
thanks for your ideas.!