How to Cum Mean Row by Row

[#1]

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

[#2 · Accepted solution]

New Column("Moving Average",

    Numeric,

    Formula(

        If(Row() == 1,

            :CUSTOMER SATISFACTION INDEX,

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

        )

    )

);

[#3]

Thank you!

[#4]

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