I understand that a non-numeric field import can cause this issue, however I have many number fields displaying NaN. I am unable to remove them, even by deletion of the field value. All I can do is enter a zero value. I would rather have a blank field if the value is zero.
What can I do, if anything?
Did you import data into this field, perhaps including a currency symbol? That might have caused this.
Does it happen with new records too?
Thanks,
Brendan
Yes, I imported Bento number data that had currency symbols in it.
I have exported to a csv, cleaned out all the $ symbols, and then re-imported into a new DB with the same structure. No fix. Still have many “NaN” showing. The csv file I am importing from has no data, zero, nothing, between the commas.
This makes me think something in the database structure is causing this as I duplicated and renamed the original DB, leaving a new, empty DB prior to importing the csv.
Remove commas from your data too. There should be only digits and a decimal point. Commas are just extraneous formatting which gets applied after the fact depending on your region settings.
Thanks,
Brendan
.
