12489_en-US

liliconcom

How to Cum Mean Row by Row<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

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?

Many thanks in advance

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...

Many thanks in advance

Re: How to Cum Mean Row by Row

Thank you!

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()

        )

    )

);