Mean value for empty cells with column

[#1]

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,

[#2 · Accepted solution]

Here is a column formula that works 

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

[#3 · Accepted solution]

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)
,
	.
)