# Can't push decimal numbers
**URL:** https://discuss.elastic.co/t/cant-push-decimal-numbers/100960
**Category:** Elasticsearch
**Created:** [September 19, 2017, 6:14am UTC](https://discuss.elastic.co/t/cant-push-decimal-numbers/100960 "2017-09-19T06:14:55Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@tomer](https://discuss.elastic.co/u/tomer)
#### Post date: [September 19, 2017, 6:14am UTC](https://discuss.elastic.co/t/cant-push-decimal-numbers/100960/1 "2017-09-19T06:14:56Z")
Hi,
I am having a problem getting decimal numbers in the ES
as shown below:
I have an "ASR" that is 0.9, but when I use the following query:
GET filebeat-\*/log/\_search
{
"query": {
```
"bool":{
"must": [
{ "match": { "ASR": "0.9"}}
]
}
}
}
```
I get:
```
> {
> "took": 1,
> "timed_out": false,
> "_shards": {
> "total": 2,
> "successful": 2,
> "failed": 0
> },
> "hits": {
> "total": 0,
> "max_score": null,
> "hits": []
> }
> }
```
The log its self is as following:
"{"eventTimestamp":1505760179999,"asrFrom":1505759776499,"ASR":0.9}"
Help will be great I am gravely under pressure on this subject.
---
### Author:  [@jogoinar10](https://discuss.elastic.co/u/jogoinar10)
#### Post date: [September 19, 2017, 6:41am UTC](https://discuss.elastic.co/t/cant-push-decimal-numbers/100960/2 "2017-09-19T06:41:13Z")
Did you try to remove the qoutes?
---
### Author:  [@tomer](https://discuss.elastic.co/u/tomer)
#### Post date: [September 19, 2017, 6:41am UTC](https://discuss.elastic.co/t/cant-push-decimal-numbers/100960/3 "2017-09-19T06:41:55Z")
Hi,
Yes, I tried ☹
Also in the visualization, it shows as if there is only 0 or 1
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [September 19, 2017, 7:17am UTC](https://discuss.elastic.co/t/cant-push-decimal-numbers/100960/4 "2017-09-19T07:17:37Z")
What is the mapping for that field?
---
### Author:  [@tomer](https://discuss.elastic.co/u/tomer)
#### Post date: [September 19, 2017, 7:25am UTC](https://discuss.elastic.co/t/cant-push-decimal-numbers/100960/5 "2017-09-19T07:25:34Z")
I actually solved this by pushing in percentage instead of decimal such as instead of .5 =\> 50, but I am still interested why is this happening, so here is my mapping:
"ASR": {
"type": "long"
},
---
### Author:  [@jogoinar10](https://discuss.elastic.co/u/jogoinar10)
#### Post date: [September 19, 2017, 7:35am UTC](https://discuss.elastic.co/t/cant-push-decimal-numbers/100960/6 "2017-09-19T07:35:30Z")
Sorry, i'm not used to mapping.
I just always index the data directly
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [September 19, 2017, 8:12am UTC](https://discuss.elastic.co/t/cant-push-decimal-numbers/100960/7 "2017-09-19T08:12:41Z")
In order to store floats, you need to map the field as [float or double](https://www.elastic.co/guide/en/elasticsearch/reference/5.6/number.html) instead of long. This will require reindexing.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 17, 2017, 8:13am UTC](https://discuss.elastic.co/t/cant-push-decimal-numbers/100960/8 "2017-10-17T08:13:02Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.