topic Mean value for empty cells with column in Discussions

Mean value for empty cells with column

chandankishor66 — Fri, 09 Jun 2023 16:01:52 GMT

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,

Re: Mean value for empty cells with column

txnelson — Mon, 07 Nov 2022 07:01:43 GMT

Here is a column formula that works

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

Re: Mean value for empty cells with column

jthi — Mon, 07 Nov 2022 07:04:13 GMT

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