Math Formula Multi Column, Column Average

KNIME Analytics Platform
2

Hi @smithcreed check this post: Calculate mean ignoring zeros. First convert the zeros to NaN with ```
if($CURRENT_COLUMN$ == 0, “NaN”, $CURRENT_COLUMN$)

and then use COLMEAN
2 Likes