Forum Discussion

spencer_g's avatar
spencer_g
Icon for Helper I rankHelper 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 vis...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity 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
    Icon for Helper I rankHelper 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!

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      9 years ago

      Cool, let me know if it works for you.