Cumulative Values..

[sravan_v007]

Hi All,

Need help in Cumulative Calculation..

I Have a table like...

Names           Values

A                    10

B                    20

C                    30

now I want a new Colume with Cumlative Values

Like..

Cumulative_Values

10                    =10

(10+20)/2          =15

(10+20+30)/3     =20

Thanks in Advance...

[swuehl]

Maybe like

=rangesum( above( sum( Value),0,rowno() )) / rowno()

[tresesco]

PFA

[#4]

try this code

RangeSum(Above(sum( Values),0,RowNo()))/RowNo()

then output like this

Names	Values	Accumulate
A	10	10
B	20	15
C	30	20

[#5]

Hi, check the example