VB Crystal Report, summing a running total

summing a running total

Author	Message
Pathfinde #1 / 3	summing a running total has anyone any ideas, please on how I might be able to get round the problem of trying to sum a running total. I have some data with a list of transactions together with the budget for that a/c code for the year. I have to put the budget figure into the group total & not the detail because otherwise the budget total for the a/c code is budget times no. of transactions. I then use the running total to sum these totals. I would then like to add these running totals. Would a formula field where I have sum (budget)/count (budget) and hide duplicate entries work? Could I then sum those fields? TIA Lee
Sat, 25 Oct 2003 23:04:08 GMT

Bob Holme #2 / 3	summing a running total Hi Lee, I would try a formula with a variable that you keep incrementing by the running total amount. Bob Holmes Quote: > has anyone any ideas, please on how I might be able to get round the problem > of trying to sum a running total. > I have some data with a list of transactions together with the budget for > that a/c code for the year. I have to put the budget figure into the group > total & not the detail because otherwise the budget total for the a/c code > is budget times no. of transactions. I then use the running total to sum > these totals. I would then like to add these running totals. > Would a formula field where I have sum (budget)/count (budget) and hide > duplicate entries work? Could I then sum those fields? > TIA > Lee
Sat, 25 Oct 2003 23:23:12 GMT

Howard Hammerma #3 / 3	summing a running total Here is how I would handle it: Simply create another running total and in that total adjust the accumulation rule so that it accumulated once per group and does not reset. There is no need to put the raw field in the report at all. Howard Hammerman Hammerman Associates, Inc. www.hammerman.com Crystal Reports classes, books, consulting, support 800-783-6626 Quote: >has anyone any ideas, please on how I might be able to get round the problem >of trying to sum a running total. >I have some data with a list of transactions together with the budget for >that a/c code for the year. I have to put the budget figure into the group >total & not the detail because otherwise the budget total for the a/c code >is budget times no. of transactions. I then use the running total to sum >these totals. I would then like to add these running totals. > Would a formula field where I have sum (budget)/count (budget) and hide >duplicate entries work? Could I then sum those fields? >TIA >Lee
Sun, 26 Oct 2003 00:06:21 GMT

Page 1 of 1

[ 3 post ]