Hello,

I was wondering if there was any way to calculate a mean on several columns despite missing values ?

I attached a small simple example file.

In fact, when I add a computed variable and enter the mean formula, the mean is calculated only when all the columns have a value. When there is one missing value in a column, the mean is not calculated. When there is a missing value, I would like to calculate the mean on the others values, "ignoring" the missing one. Is it possible ?

Thanks for the help !