# Update elasticsearch with calculation on fields

**URL:** https://discuss.elastic.co/t/update-elasticsearch-with-calculation-on-fields/39497
**Category:** Elasticsearch
**Created:** [January 19, 2016, 3:44am UTC](https://discuss.elastic.co/t/update-elasticsearch-with-calculation-on-fields/39497 "2016-01-19T03:44:07Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![gpong](https://avatars.discourse-cdn.com/v4/letter/g/d6d6ee/32.png) [@gpong](https://discuss.elastic.co/u/gpong)
#### Post date: [January 19, 2016, 3:44am UTC](https://discuss.elastic.co/t/update-elasticsearch-with-calculation-on-fields/39497/1 "2016-01-19T03:44:07Z")

</div>

Hi Guys,

Can I used elasticsearch update for calculate the same fields with plus or minus value??  
for example :  
first I have this document on elasticsearch  
{  
"part\_no":"aa.bbbb.001ZZ",  
"stock\_qty":"20.000",  
"warehouse\_qty":"10.000"  
}

then I insert new document

{  
"part\_no":"aa.bbbb.001ZZ",  
"stock\_qty":"5.000",  
"warehouse\_qty":"-3.000"  
}

can I use update API to do some calculation for stock\_qty (+5) and warehouse\_qty (-3)?  
and the result will be like

{  
"part\_no":"aa.bbbb.001ZZ",  
"stock\_qty":"25.000",  
"warehouse\_qty":"7.000"  
}

Thanks

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [January 20, 2016, 9:47pm UTC](https://discuss.elastic.co/t/update-elasticsearch-with-calculation-on-fields/39497/2 "2016-01-20T21:47:57Z")

</div>

I think you can do this with [scripted updates](https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-update.html#_scripted_updates).

---

<div class="post-metadata">

### Author: ![gpong](https://avatars.discourse-cdn.com/v4/letter/g/d6d6ee/32.png) [@gpong](https://discuss.elastic.co/u/gpong)
#### Post date: [January 21, 2016, 12:59am UTC](https://discuss.elastic.co/t/update-elasticsearch-with-calculation-on-fields/39497/3 "2016-01-21T00:59:58Z")

</div>

Thanks Warkolm

---

<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:22pm UTC](https://discuss.elastic.co/t/update-elasticsearch-with-calculation-on-fields/39497/4 "2017-07-05T23:22:50Z")

</div>