# Bad number display regardless of Mapping used (float, double)
**URL:** https://discuss.elastic.co/t/bad-number-display-regardless-of-mapping-used-float-double/206297
**Category:** Elasticsearch
**Created:** [November 3, 2019, 4:53pm UTC](https://discuss.elastic.co/t/bad-number-display-regardless-of-mapping-used-float-double/206297 "2019-11-03T16:53:39Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@crpj](https://discuss.elastic.co/u/crpj)
#### Post date: [November 3, 2019, 4:53pm UTC](https://discuss.elastic.co/t/bad-number-display-regardless-of-mapping-used-float-double/206297/1 "2019-11-03T16:53:39Z")
Hello all 😀
After researching and testing I could not figure out why I am still getting wrong numbers returned by queries regardless of the mapping used. E.g. 8.217157748 **E9**
I tried float and double. For the reference, here's a non-aggregated value: 0.3910399955129833
> PUT \_template/aggregated-template
> {
> "index\_patterns":["aggregated-\*"],
> "settings": {
> "number\_of\_shards":1
> },
> "mappings":{
> "\_source": {
> "enabled": true
> },
> "properties": {
> #omitted a few fields here, important ones below
> "CALL\_COUNT" : {"type" : "integer"},
> "CHARGED\_USAGE" : {"type" : "double"},
> "DATA\_VOLUME" : {"type" : "double"},
> "AMOUNT" : {"type" : "double"}
> }
> }
> }
> #query results
> {
> "key" : 1570579200000,
> "key\_as\_string" : "20191009",
> "doc\_count" : 6,
> "SUM\_CHARGED\_USAGE" : {
> "value" : 8.193465344020516 **E9**
> },
> "SUM\_CALL\_COUNT" : {
> "value" : 14.0
> },
> "SUM\_DATA\_VOLUME" : {
> "value" : 8.217157748 **E9**
> },
> "SUM\_AMOUNT" : {
> #OK here, why?
> "value" : 432.98415810004917
> }
> }
Thank you for any guidance.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 1, 2019, 4:53pm UTC](https://discuss.elastic.co/t/bad-number-display-regardless-of-mapping-used-float-double/206297/2 "2019-12-01T16:53:46Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.