# How to subtract between two fields?
**URL:** https://discuss.elastic.co/t/how-to-subtract-between-two-fields/101250
**Category:** Kibana
**Created:** [September 21, 2017, 12:09am UTC](https://discuss.elastic.co/t/how-to-subtract-between-two-fields/101250 "2017-09-21T00:09:24Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@adnil](https://discuss.elastic.co/u/adnil)
#### Post date: [September 21, 2017, 12:09am UTC](https://discuss.elastic.co/t/how-to-subtract-between-two-fields/101250/1 "2017-09-21T00:09:24Z")
New to this but tried to follow the Elastic docs and it didn't work for me. Trying to create a Visualizer where I want to subtract field1 from field2 using the Advanced JSON scripting. Keeps saying I have an error but not sure what the error is. Tried also with 'Filters' aggregation and got same result. I must be missing something very simple so please guide me; please see attached screenshots. Thanks.
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [September 21, 2017, 4:02am UTC](https://discuss.elastic.co/t/how-to-subtract-between-two-fields/101250/2 "2017-09-21T04:02:25Z")
You will probably want to create a scripted field instead [https://www.elastic.co/guide/en/kibana/5.6/scripted-fields.html](https://www.elastic.co/guide/en/kibana/5.6/scripted-fields.html)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 19, 2017, 4:03am UTC](https://discuss.elastic.co/t/how-to-subtract-between-two-fields/101250/3 "2017-10-19T04:03:17Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.