# Aggregation on double field

**URL:** <https://discuss.elastic.co/t/aggregation-on-double-field/43680>\
**Category:** Elasticsearch\
**Created:** [March 7, 2016, 5:03pm UTC](https://discuss.elastic.co/t/aggregation-on-double-field/43680 "2016-03-07T17:03:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ozgur\_O\_Akdemirci](https://avatars.discourse-cdn.com/v4/letter/o/e47c2d/32.png) [@Ozgur\_O\_Akdemirci](https://discuss.elastic.co/u/Ozgur_O_Akdemirci)\
**Post date:** [March 7, 2016, 5:03pm UTC](https://discuss.elastic.co/t/aggregation-on-double-field/43680/1 "2016-03-07T17:03:16Z")

</div>

Hi all,  
I've installed ES on a cluster, first I added a mapping, then put the data on the index.  
On a double type field I query for an aggregation.

GET myindex/mytype/\_search  
{  
"query": {  
"filtered": {  
"query": {  
"match": {  
"myField": 10  
}  
},  
"filter": {  
"range": {  
"myDateField": {  
"gt": "2015-01-01"  
}  
}  
}  
}  
},  
"aggs": {  
"sumOfAMeasureField": {  
"sum": {  
"field": "myMoneyField"  
}  
}  
}  
}

Each run shows different results, like below. there are no failing shards, the number of rows returned is same, but the agg differs

3408065.5425  
3408064.765

Any comment?  
Regards and thanks

Özgür

---

<div class="post-metadata">

**Author:** ![jpountz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jpountz/32/45836_2.png) [@jpountz](https://discuss.elastic.co/u/jpountz)\
**Post date:** [March 8, 2016, 10:06am UTC](https://discuss.elastic.co/t/aggregation-on-double-field/43680/2 "2016-03-08T10:06:29Z")

</div>

This is likely due to floatig point rounding errors: floating point numbers can only approximately represent most values. This means that doing `sum = a; sum += b; sum +=c` can return a different result from doing `sum = c; sum += b; sum +=a` since the approximation errors accumulate differently. There is nothing to worry about, this is just the way that floating point numbers work.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 11:10pm UTC](https://discuss.elastic.co/t/aggregation-on-double-field/43680/3 "2017-07-05T23:10:26Z")

</div>