I have linked a dataset to a table in perspective. The table does not show scientific notation. When I enter values is removes the scientific notation.
Example:
The value in the dataset is 6.9592e-8. The table displays NaN. (see below).
I changed the number format from 0,0.## to "0.00e+0"
The displayed value is correct (no longer NaN) but when I enter a new value , it displays e+0 rather than e-8. Plus, I don't want my values all displayed in scientific notation, just the very big and very small numbers.
I've never actually run into the problem. I happened to see the other post in the last couple of days and remembered it.
You have two choices. If the dataset is coming from a database query you could sort it out at the SQL level. If not (or if the dataset is coming from something else) you could run a script transform on the dataset.
Please explain your configuration and what you want to happen with small numbers. e.g., Do you want to round anything below 0.0005 to zero?
Again, I may not be your best hope of success. It's still not clear to me whether 6.9592e-8 is the actual value you want to store or if it's a rounding error that you want to get rid of. If it's the latter can you use a Python / Jython floor() function?
Yes, I want to store very small numbers like 7.8888e-8. ( and very large ones too ) I know there are rounding errors when you get into the weeds with floating point storage but I am not worried about those errors I just want to understand why the exponent is removed when I enter values into the data table.