How excluding each row in a formula?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
Re: How excluding each row in a formula?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
