Bin with long decimal

[narissa]

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

[v-jingzhang · Accepted solution]

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.

[amitchandak]

@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