# Division in Scripted field

**URL:** <https://discuss.elastic.co/t/division-in-scripted-field/244715>\
**Category:** Kibana\
**Created:** [August 12, 2020, 12:50pm UTC](https://discuss.elastic.co/t/division-in-scripted-field/244715 "2020-08-12T12:50:23Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [August 12, 2020, 1:35pm UTC](https://discuss.elastic.co/t/division-in-scripted-field/244715/2 "2020-08-12T13:35:45Z")

</div>

Painless is basically Java, and your variables are all integers, this is why you are getting zero (it's only doing integer division): [Painless integer division](https://discuss.elastic.co/t/painless-integer-division/150386)

Cast your variables to float before doing the division, then it should work like you expect.

---

_[View the full topic](https://discuss.elastic.co/t/division-in-scripted-field/244715)._