# I am un able to get any result by using divide operator in Kibana 4.3
**URL:** https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405
**Category:** Kibana
**Created:** [March 3, 2016, 3:25pm UTC](https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405 "2016-03-03T15:25:41Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@mrizwan](https://discuss.elastic.co/u/mrizwan)
#### Post date: [March 3, 2016, 3:25pm UTC](https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405/1 "2016-03-03T15:25:41Z")
My divide operator is not working
I am doing this :
doc['total calls offered'].value/doc['total calls abandon'].value
However,
I am getting result by using add (+) operator
doc['total calls offered'].value+doc['total calls abandon'].value
Please guide.
---
### Author:  [@Court](https://discuss.elastic.co/u/Court)
#### Post date: [March 3, 2016, 3:46pm UTC](https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405/2 "2016-03-03T15:46:11Z")
I'm not 100% on this, but I don't believe lucene query syntax supports arithmetic. I think the + operator is just an alias of AND.
---
### Author:  [@mrizwan](https://discuss.elastic.co/u/mrizwan)
#### Post date: [March 3, 2016, 3:54pm UTC](https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405/3 "2016-03-03T15:54:58Z")
but in Kibana, they have mentioned that we can use / operator . And + operator is adding my values not concatenating them.
---
### Author:  [@Court](https://discuss.elastic.co/u/Court)
#### Post date: [March 3, 2016, 3:57pm UTC](https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405/4 "2016-03-03T15:57:38Z")
I may have misunderstood your issue: are you doing this in a scripted field?
---
### Author:  [@mrizwan](https://discuss.elastic.co/u/mrizwan)
#### Post date: [March 4, 2016, 8:22am UTC](https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405/5 "2016-03-04T08:22:58Z")
yes i want to make a scripted field.
---
### Author:  [@BigFunger](https://discuss.elastic.co/u/BigFunger)
#### Post date: [March 4, 2016, 5:39pm UTC](https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405/6 "2016-03-04T17:39:47Z")
I was able to index some records and create the specified scripted field (see below). How are the fields that you are trying to use mapped in your elasticsearch index?
---
### Author:  [@mrizwan](https://discuss.elastic.co/u/mrizwan)
#### Post date: [March 7, 2016, 1:33pm UTC](https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405/7 "2016-03-07T13:33:23Z")
I have tried as you showed in your example but I am getting errors while making visualizations.
Their data type is long PFB the mapping:
"Total Calls Abandon": {
"type": "long"
},
"Total Calls Offered": {
"type": "long"
---
### Author:  [@mrizwan](https://discuss.elastic.co/u/mrizwan)
#### Post date: [March 7, 2016, 1:34pm UTC](https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405/8 "2016-03-07T13:34:57Z")
and i am using this script in kibana
doc['Total Calls Abandon']/doc['Total Calls Offered'] this is giving me error.
and doc['Total Calls Abandon'].value/doc['Total Calls Offered'].value is giving me blank visualization.
---
### Author:  [@BigFunger](https://discuss.elastic.co/u/BigFunger)
#### Post date: [March 7, 2016, 4:21pm UTC](https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405/9 "2016-03-07T16:21:58Z")
The only thing that I see was different between my example and yours was that you had spaces in the your field names. I Recreated it the best that I could with the information that I have and was still unable to replicate the issue. Here is my mapping:
```auto
{
"funger2": {
"mappings": {
"calls": {
"properties": {
"@timestamp": {
"type": "date",
"format": "strict_date_optional_time||epoch_millis"
},
"total calls abandon": {
"type": "long"
},
"total calls offered": {
"type": "long"
}
}
}
}
}
}
```
I WAS able to get an error message to happen if I didn't type the fields name exactly **including case** when building my scripted field.
Can you please supply your mapping, and a sample of data so that I can recreate it better? Also, what exactly is the error message that you are receiving?
---
### Author:  [@mrizwan](https://discuss.elastic.co/u/mrizwan)
#### Post date: [March 8, 2016, 9:21am UTC](https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405/10 "2016-03-08T09:21:25Z")
Jim thanks for ur reply. Below is the overall mapping and attached are the snapshots for reference. 
{
"cc\_stats": {
"mappings": {
"ccstats\_report": {
"properties": {
"Call Date": {
"type": "date",
"format": "dateOptionalTime"
},
"Total Calls Abandon": {
"type": "long"
},
"Total Calls Answered": {
"type": "long"
},
"Total Calls Initiated": {
"type": "long"
},
"Total Calls Offered": {
"type": "long"
}
}
}
}
}
}
---
### Author:  [@BigFunger](https://discuss.elastic.co/u/BigFunger)
#### Post date: [April 5, 2016, 3:43pm UTC](https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405/11 "2016-04-05T15:43:33Z")
@mrizwan were you able to get this to work? I have been away and apologize for my lapse in communication.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:56pm UTC](https://discuss.elastic.co/t/i-am-un-able-to-get-any-result-by-using-divide-operator-in-kibana-4-3/43405/12 "2017-07-06T13:56:55Z")