# Scripted field
**URL:** https://discuss.elastic.co/t/scripted-field/260675
**Category:** Elasticsearch
**Created:** [January 11, 2021, 5:54am UTC](https://discuss.elastic.co/t/scripted-field/260675 "2021-01-11T05:54:59Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Jerry\_Yap](https://discuss.elastic.co/u/Jerry_Yap)
#### Post date: [January 11, 2021, 5:54am UTC](https://discuss.elastic.co/t/scripted-field/260675/1 "2021-01-11T05:54:59Z")
Hi all,
My index fields consists of
1. index\_name (containing P01, P02)
2. X (numbers)
How can i scripted the field to display the subtracted result of P01 of X - P02 of X?
Thanks in advance.
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [January 11, 2021, 7:59am UTC](https://discuss.elastic.co/t/scripted-field/260675/2 "2021-01-11T07:59:41Z")
Can you please show an example document and what the expected output would be?
---
### Author:  [@Jerry\_Yap](https://discuss.elastic.co/u/Jerry_Yap)
#### Post date: [January 11, 2021, 8:24am UTC](https://discuss.elastic.co/t/scripted-field/260675/3 "2021-01-11T08:24:01Z")
Hi Christian,
X of P01 = 10
X of P02 = 8
Graph to show net value of X - 2
Thanks
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [January 11, 2021, 8:26am UTC](https://discuss.elastic.co/t/scripted-field/260675/4 "2021-01-11T08:26:25Z")
That does not show the document structure. Scripted fields are limited to the scope of a single document, so if these values reside in different documents you will not be able to use scripted fields.
---
### Author:  [@Jerry\_Yap](https://discuss.elastic.co/u/Jerry_Yap)
#### Post date: [January 13, 2021, 3:34am UTC](https://discuss.elastic.co/t/scripted-field/260675/5 "2021-01-13T03:34:06Z")
Apologies for late reply, hope this helps. Can I script to subtract X from different index\_name in same index pattern?
"\_source": {
"index\_name": "P01",
},
"statistic\_type": "count",
"x": 10
"\_source": {
"index\_name": "P02",
},
"statistic\_type": "count",
"x": 2
Thanks.
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [January 13, 2021, 6:06am UTC](https://discuss.elastic.co/t/scripted-field/260675/6 "2021-01-13T06:06:43Z")
No. Scripted fields require all data to be in a single document.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 10, 2021, 6:06am UTC](https://discuss.elastic.co/t/scripted-field/260675/7 "2021-02-10T06:06:51Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.