summing a running total
Author Message 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  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  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 ]

Relevant Pages