Mean value for empty cells with column

Question

HI,

I am tring to calculate mean for a column. The Mean have calcuated well for :Column 1 but their empty cells have also filled with mean values.

I donot want mean values to be filled for empty cell.

Is other any way to get rid of mean value for empty cell.

Regards,

txnelson · Accepted Answer

Here is a column formula that works

If( Is Missing( :Column 1 ) == 0,
	Col Mean( :Column 1 )
)

jthi · Accepted Answer

You can check for missing values by using If-statement with IsMissing and if the value isn't missing add mean otherwise add missing value (note the "!" in formula for Not()).

If(!Is Missing(:Column 1),
	Col Mean(:Column 1)
,
	.
)