Forum Discussion
Bin with long decimal
Hi
I tried to find this elsewhere but no luck so asking in the forum. I created a straightforward group of bins of Full-time equivalents into groups of one day. For some reason, the .6 FTE has the additional .0000000001.
Is this a bug due to the limitations of floating-point values much like Python?
Is there a way to correct/tidy/rename the bins?
I have included a snip of the bin, the visualisation and the data when viewed as a table.
thanks
Narissa
Hi narissa
You could correct it by selecting this bin field and changing its format to having 1 digit after decimal point.
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
2 Replies
- amitchandak
Super User
narissa , Can you share sample data and sample output in a table format?
Can you check if you create manual bins using the independent table approach? refer https://www.youtube.com/watch?v=CuczXPj0N-k
v-jingzhangCommunity Support
Hi narissa
You could correct it by selecting this bin field and changing its format to having 1 digit after decimal point.
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
