# Painless script error
**URL:** https://discuss.elastic.co/t/painless-script-error/306243
**Category:** Kibana
**Tags:** painless
**Created:** [June 2, 2022, 2:43pm UTC](https://discuss.elastic.co/t/painless-script-error/306243 "2022-06-02T14:43:11Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Surya\_Raviraj](https://discuss.elastic.co/u/Surya_Raviraj)
#### Post date: [June 2, 2022, 2:43pm UTC](https://discuss.elastic.co/t/painless-script-error/306243/1 "2022-06-02T14:43:11Z")
Hi, I have a script below -
if(doc['not\_shipped\_shortfall'].value \< 0) { return doc['not\_shipped\_shortfall'].value; }else{ return 0; }
when I click 'preview results' I see my desired result and looks like the script is working fine. However, when I try to use this metric in the visualizer I get the following error -
```auto
org.elasticsearch.index.fielddata.ScriptDocValues$Doubles.get(ScriptDocValues.java:249)
org.elasticsearch.index.fielddata.ScriptDocValues$Doubles.getValue(ScriptDocValues.java:243)
if(doc['not_shipped_shortfall'].value < 0.0) {
^---- HERE
```
I'd greatly appreciate if you can point me in the right direction.
---
### Author:  [@marone](https://discuss.elastic.co/u/marone)
#### Post date: [June 2, 2022, 4:11pm UTC](https://discuss.elastic.co/t/painless-script-error/306243/2 "2022-06-02T16:11:04Z")
> [@Surya\_Raviraj](#):
>
> if(doc['not\_shipped\_shortfall'].value \< 0) { return doc['not\_shipped\_shortfall'].value; }else{ return 0; }
Hey @Surya_Raviraj ,
First, I created a `test` index with only one field to test:
```auto
PUT test
{
"mappings": {
"properties": {
"float_field": {
"type": "float"
}
}
}
}
POST test/_doc/1
{
"float_field": 1.2
}
POST test/_doc/2
{
"float_field": -1.2
}
```
Then copied/pasted your code as it is and worked in the scripted field in the index pattern:
```auto
if(doc['float_field'].value < 0) {
return doc['float_field'].value;
}
else {
return 0;
}
```
the script above worked for me in the previou results tab
Can you please tell us additional information: what elastic version are you using? and also paste the whole stack trace, there is a reason field at the bottom of the error.
and I can use the `new_field` created in a vizualisation:
**FYI I tested that on elastic 8.0.1.**
---
### Author:  [@Surya\_Raviraj](https://discuss.elastic.co/u/Surya_Raviraj)
#### Post date: [June 2, 2022, 4:28pm UTC](https://discuss.elastic.co/t/painless-script-error/306243/3 "2022-06-02T16:28:24Z")
Thanks Marone, I am currently using elastic version 7.10.
How can I find the whole stack trace? The error message I pasted was copied when I try to use it in a visualization.
---
### Author:  [@Surya\_Raviraj](https://discuss.elastic.co/u/Surya_Raviraj)
#### Post date: [June 2, 2022, 6:34pm UTC](https://discuss.elastic.co/t/painless-script-error/306243/4 "2022-06-02T18:34:58Z")
Something to also note that is that the field I am working with has a mapping type of double. Fortunately, all the numbers in that field are/can only whole numbers. Not sure if that changes anything.
---
### Author:  [@marone](https://discuss.elastic.co/u/marone)
#### Post date: [June 3, 2022, 12:55pm UTC](https://discuss.elastic.co/t/painless-script-error/306243/5 "2022-06-03T12:55:23Z")
I updated the mapping to double and still working.
For the whole stacktrace I thought it was printed from Elasticsearch side, but since you got it when trying to make the vizualisation, the code is executed on the kibana side.
Do you have the new field processed on Discover tab? Like this:
---
### Author:  [@Surya\_Raviraj](https://discuss.elastic.co/u/Surya_Raviraj)
#### Post date: [June 6, 2022, 3:29pm UTC](https://discuss.elastic.co/t/painless-script-error/306243/6 "2022-06-06T15:29:58Z")
Yes, I am able to see the values on the discover tab. I am not able to use this field on my visualization though. That's what is confusing me. Any hints or tips that you might have?
---
### Author:  [@marone](https://discuss.elastic.co/u/marone)
#### Post date: [June 7, 2022, 9:00am UTC](https://discuss.elastic.co/t/painless-script-error/306243/7 "2022-06-07T09:00:32Z")
That's confusing me as well, maybe if you can update your elastic to a newer version? or try to create an issue on [Issues · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 5, 2022, 9:01am UTC](https://discuss.elastic.co/t/painless-script-error/306243/8 "2022-07-05T09:01:28Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.