Json members that are decimals getting cut off
Jamanya opened this issue · 1 comments
Jamanya commented
when exporting a dataset that has a float or decimal, it appears that this is truncating the numbers:
for example, we have a dataset field that follows a 7.5 pattern i. e 1234567.12345 in the csv, it appears like this '
231380.0023
where the above number should be 231380.00231
or if the number after the decimal place starts with 0, it completely removed everything after the decimal, for example,
it should be this:
2071090.00005
but getting this:
2071090
our dataset even though it looks like a float, this pattern is actually a string from the api
Jamanya commented
Looks like it was an issue with the default behavior of Microsoft Excel and how it treats data