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 · Accepted solution]

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

[JShankman]

i like the Summarize tool using "Average - Ignore 0's" option.

Alternatively, you can filter on the field Where [rent/sq q] != 0, and then perform your average calculation. Depending on the next use for the data, there are many ways to accomplish this.