I am working with a data set that has multiple contributors. Unfortunately many of them enter data their own way.
Specifically, I am looking at Diabetic A1C data. One person might enter it is as 5.765, another 5.76%, yet another 5.764444E3, and then another would enter something as 93 MG/L.
Is there any formula or DOMO tool that I can use to only accept the decimal version of this data? Or, can I tell DOMO to convert bad data into nulls so I can get rid of them? It's annoying that when someone enters data wrong, it can no longer be read as a number.