Choose Language Hide Translation Bar

Community Trekker

Joined:

Sep 29, 2014

## How to Cum Mean Row by Row

Hi all,

I have a column which displays the satisfaction percentage and I would like to have another column which takes the Cumulative Mean row by row. What is the script for it?

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Joined:

Jun 23, 2011

Solution

## Re: How to Cum Mean Row by Row

New Column("Moving Average",

Numeric,

Formula(

If(Row() == 1,

:CUSTOMER SATISFACTION INDEX,

(:Moving Average[Row() - 1] * (Row() - 1) + :CUSTOMER SATISFACTION INDEX) / Row()

)

)

);

3 REPLIES 3

Super User

Joined:

Jun 23, 2011

Solution

## Re: How to Cum Mean Row by Row

New Column("Moving Average",

Numeric,

Formula(

If(Row() == 1,

:CUSTOMER SATISFACTION INDEX,

(:Moving Average[Row() - 1] * (Row() - 1) + :CUSTOMER SATISFACTION INDEX) / Row()

)

)

);

Community Trekker

Joined:

Sep 29, 2014

## Re: How to Cum Mean Row by Row

Thank you!

Community Trekker

Joined:

Sep 29, 2014

## Re: How to Cum Mean Row by Row

Hi MS,

Would you please show me how to add "by variable" to the script above?

CSI by Year,

CSI by Year by Agency

CSI By Year by Agency by Month...