# How to divide two fields in kibana

**URL:** https://discuss.elastic.co/t/how-to-divide-two-fields-in-kibana/158291
**Category:** Elasticsearch
**Created:** [November 27, 2018, 8:19am UTC](https://discuss.elastic.co/t/how-to-divide-two-fields-in-kibana/158291 "2018-11-27T08:19:26Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Nitanshu](https://avatars.discourse-cdn.com/v4/letter/n/ebca7d/32.png) [@Nitanshu](https://discuss.elastic.co/u/Nitanshu)
#### Post date: [November 27, 2018, 8:19am UTC](https://discuss.elastic.co/t/how-to-divide-two-fields-in-kibana/158291/1 "2018-11-27T08:19:26Z")

</div>

I have the following query and it shows error  
"type": "x\_content\_parse\_exception",  
"reason": "[4:8] [sum] unknown field [RESULT], parser not found"  
I am using Kibana , elasticsearch and logstash  
My query is

GET ipvidentixkpi/\_search  
{"aggs": {  
"sum\_1": {  
"sum": {  
"RESULT": "FAILURE"  
}  
},  
"sum\_2": {  
"sum": {  
"SERVICE\_PROVIDER": "IDENTIX"  
}  
},  
"division": {  
"bucket\_script": {  
"buckets\_path": {  
"my\_var1": "sum\_1",  
"my\_var2": "sum\_2"  
},  
"script": "params.my\_var1 / params.my\_var2"  
}  
}  
}  
}  
Plz help

---

<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: [December 25, 2018, 8:19am UTC](https://discuss.elastic.co/t/how-to-divide-two-fields-in-kibana/158291/2 "2018-12-25T08:19:28Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
