565570_en-US

liliconcom

Mean value for empty cells with column

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,

 

 

ScriptingRe: Mean value for empty cells with column

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

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