Truncated float number to int problem

I have a float number of shipping price. When I go to new table in dashboard, this field has a integer number.

Have you tried to download the Raw CSV from the inspector screen to check how the actual data looks like?

Alternatively you can also check the Elasticsearch response switching from the View: Data option to Requests, and there see the Response tab and look for your numbers. In my case the $39.49 value from the second row is actually 39.4921875.

Finally, your first screenshot does not show any specific value for the format. If I remove the format for the field on my table I get three decimals so it is not exactly the same you are showing.

I'm also running my tests on 8.7.1 so it would be good to know which version are you running as well.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.