How excluding each row in a formula?

Question

Hi Everybody,

I'm trying to create a new column with a formula in a data table. 
This formula should give me the mean of another column, by category, excluding the actual row. So after Ican compare the row value with the mean of the group (without this row used in the formula).

Is it clear?
How can I do that?

Thank a lot,

Florence

brady_brady · Accepted Answer

Hi Florence,

One way to do this without having to exclude rows (here I use Car Physical Data's weight and type columns as examples) is to divide the difference of the current group sum and the current row value, by 1 less than the number of items in the group.

Cheers,

Brady