Forum Discussion

spencer_g's avatar
spencer_g
Helper I
9 years ago

Convert Errors to 0

Hi Everyone, 

 

I have data that is updated automatically, and the original inputs are keyed on by people filling out an online questionaire. One of the questions is for zip code, and sometimes visitors to the site accidently key in a letter in the zip code which causes an error message when I refresh the data. 

 

I know there is a way to remove errors, but I would prefer to have the errors automatically converted to a 0 so that I don't lose all of the other data associated with that visitor. 

 

Does anyone know if it is possible to convert an error to a 0?

 

Thanks in advance!

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    You could create a custom column like this:

     

    = try Number.From([Zip]) otherwise 0

    Then  remove your other column.

     

    You could also just change your Data Type in your zip to Text.

     

    • spencer_g's avatar
      spencer_g
      Helper I
      9 years ago

      Thanks smoupre! I need to have the data as a number for some of the analysis that I am doing, so I think your first suggestion will work perfectly only I will need to retain the original column. Thanks!