During Join Feature by field, sum ignores decimal values

Jean-SebastienLauzon

I am using ArcGIS online to do a join of two layers based on field match. I select one-to-one join using the statistic "sum". It works in part except that the sum ignores all decimals. E.g. 1.2+1.8=2

It does take into account all the correct elements since the Join_count values are correct.

The field type is double and I do see the decimal values in the original layer. 

Note, I'm selecting the "Create layer as a hosted feature layer view" option.

Is this a bug or is there something I'm overlooking?

Thanks

Jean-SebastienLauzon

Additional info:

If I select "Average" instead of "Sum", it works for the average. I get the correct value with decimals for the average but not for the sum.

Join_Count = 31

Join_Average = 0.1913

Join_Sum = 5

Correct sum = 5.93