# Sum of two fields into a one custom field
**URL:** https://discuss.elastic.co/t/sum-of-two-fields-into-a-one-custom-field/127600
**Category:** Elasticsearch
**Created:** [April 11, 2018, 9:47am UTC](https://discuss.elastic.co/t/sum-of-two-fields-into-a-one-custom-field/127600 "2018-04-11T09:47:53Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@prasad.ram1431](https://discuss.elastic.co/u/prasad.ram1431)
#### Post date: [April 11, 2018, 9:47am UTC](https://discuss.elastic.co/t/sum-of-two-fields-into-a-one-custom-field/127600/1 "2018-04-11T09:47:53Z")
Hi ,
I am new to elasticsearch, I have a requirement like, i have data indexed into elasticsearch, which contains all string fields. I need to do sum of two fields among them into one custom field. Is it possible to perform sum on two string fields using elasticsearch query. If its possible, kindly give me some examples.
Thank you very much in advance for your response.
Regards,
Prasad
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [April 11, 2018, 10:05am UTC](https://discuss.elastic.co/t/sum-of-two-fields-into-a-one-custom-field/127600/2 "2018-04-11T10:05:05Z")
May be using a script field. See [https://www.elastic.co/guide/en/elasticsearch/reference/6.2/search-request-script-fields.html](https://www.elastic.co/guide/en/elasticsearch/reference/6.2/search-request-script-fields.html)
But I'd recommend doing that at index time as this will slow your queries.
You can use the ingest pipeline feature and put your script there.
---
### Author:  [@prasad.ram1431](https://discuss.elastic.co/u/prasad.ram1431)
#### Post date: [April 11, 2018, 10:11am UTC](https://discuss.elastic.co/t/sum-of-two-fields-into-a-one-custom-field/127600/3 "2018-04-11T10:11:58Z")
Hi David,
Thank you for your reply, but I wanted whether this will work for String type fields or only for numeric fields.
Thanks,
Prasad
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [April 11, 2018, 10:23am UTC](https://discuss.elastic.co/t/sum-of-two-fields-into-a-one-custom-field/127600/4 "2018-04-11T10:23:32Z")
As long as it's a script it will work with whatever you want. I'm not telling you how to write the script though. Which I don't know as I'm not using painless.
I always prefer modifying my data before indexing it.
---
### Author:  [@prasad.ram1431](https://discuss.elastic.co/u/prasad.ram1431)
#### Post date: [April 11, 2018, 10:38am UTC](https://discuss.elastic.co/t/sum-of-two-fields-into-a-one-custom-field/127600/5 "2018-04-11T10:38:43Z")
thank you very much for your suggestion, but my project requirement is in this way, so i need to go this way.
Thanks,
Prasad
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [April 11, 2018, 10:58am UTC](https://discuss.elastic.co/t/sum-of-two-fields-into-a-one-custom-field/127600/6 "2018-04-11T10:58:07Z")
Good luck.
Out of curiosity, do you know why it's a requirement ?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 9, 2018, 10:58am UTC](https://discuss.elastic.co/t/sum-of-two-fields-into-a-one-custom-field/127600/7 "2018-05-09T10:58:16Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.