# Scripted field with division does not show result

**URL:** <https://discuss.elastic.co/t/scripted-field-with-division-does-not-show-result/243148>\
**Category:** Kibana\
**Created:** [July 30, 2020, 3:13am UTC](https://discuss.elastic.co/t/scripted-field-with-division-does-not-show-result/243148 "2020-07-30T03:13:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MyQuery](https://avatars.discourse-cdn.com/v4/letter/m/839c29/32.png) [@MyQuery](https://discuss.elastic.co/u/MyQuery)\
**Post date:** [July 30, 2020, 3:13am UTC](https://discuss.elastic.co/t/scripted-field-with-division-does-not-show-result/243148/1 "2020-07-30T03:13:31Z")

</div>

Hi ,  
In Scripted filed division is not working. Am not getting the returned values. Here is the snippet  
perncentile = ((failures\_AF)/(count \* 1.0));  
My Version of Kibana is 4.7.2 .

Cann some one please help me how to resolve this issue?

this field i will be using in table visualization

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [July 30, 2020, 8:15pm UTC](https://discuss.elastic.co/t/scripted-field-with-division-does-not-show-result/243148/2 "2020-07-30T20:15:17Z")

</div>

Hello,

What are you seeing instead of the values? Empty? errors? any log lines indicating something wrong?

Also we are on Kibana 7.8.0 now 🙂

Thanks,  
Bhavya

---

<div class="post-metadata">

**Author:** ![Ramadevi](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@Ramadevi](https://discuss.elastic.co/u/Ramadevi)\
**Post date:** [August 6, 2020, 2:03pm UTC](https://discuss.elastic.co/t/scripted-field-with-division-does-not-show-result/243148/3 "2020-08-06T14:03:13Z")

</div>

Hi Bhavya,

Our current Kibana version: 7.4.2

we are trying to find the percentile based on 2 columns using scripting fields

(100\*column1)/column2

Multiplication is working but division isn't happening.

Also we identified that if scripted field is added, all the properties which are shown previously are not being shown in discover tab.

After adding scripted field, we could only see scripted field in discover tab.

Could you please help on this.

Thanks & Regards,  
Ramadevi

---

<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:** [September 3, 2020, 2:03pm UTC](https://discuss.elastic.co/t/scripted-field-with-division-does-not-show-result/243148/4 "2020-09-03T14:03:20Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.