Running Total Calculation

Mon, 25 Jun 2012 17:54:24 GMT

I am trying to add a calculation of a running total column to get a weekly $and a YTD %.

When i turn on Full acumutlion for the last column I am getting

0.99

1.975

2.073

etc instead of

0.99

0.985

0.98

its adding up the entries from the prior line

WEEK	SUM(hours1) as A	SUM(hours2) as B	sum(A) / SUM(B)	SUM(RUNNING TOTAL A) / SUM(RUNNING TOTAL B)
----	------	------	---------------	-------------------------------------------
1	99	100	0.99	0.99
2	98	100	0.98	0.985
3	97	100	0.97	0.98
4	96	100	0.96	0.975
5	95	100	0.95	0.97
6	100	100	1	0.975
7	96	100	0.96	0.973
8	95	100	0.95	0.97
9	99	100	0.99	0.972
10	99	100	0.99	0.974
ETC...

-Brian

Re: Running Total Calculation

Jason_Michaelides — Mon, 25 Jun 2012 22:06:57 GMT

Hi Brian,

Your expression should be:

RangeSum(Above(Sum(Hours1),0,RowNo()))/RangeSum(Above(Sum(Hours2),0,RowNo()))

See attached.

Hope this helps,

Jason

Tue, 26 Jun 2012 12:55:14 GMT

Jason,

That worked perfect

Thanks

-Brian