Change Numeric value 0 by [Null] or Blank cell

Cedricvm

All, 
I have a column with numeric value (basically, the rent/sq m). In some of my cells, I have a numeric value 0 influencing my average... How to delete all my 0 values in the related cells, so basically how to change them by a blank cell ? 

Thanks a lot for your help,

LukeM

Hi @Cedricvm,

You could use an IF statement in a Formula tool:

IF Value = 0
THEN Null()
ELSE Value
ENDIF

It would be better to use the 'Average - Ignore 0's' option in the Summarize tool to calculate the  average without these 0 values.

Luke