Running Total Calculation

[#1]

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

[Jason_Michaelides · Accepted solution]

Hi Brian,

Your expression should be:

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

See attached.

Hope this helps,

Jason

[#3]

Jason,

     That worked perfect

Thanks

-Brian