# Inline script for round off float field is not working

**URL:** <https://discuss.elastic.co/t/inline-script-for-round-off-float-field-is-not-working/273454>\
**Category:** Kibana\
**Created:** [May 19, 2021, 10:43pm UTC](https://discuss.elastic.co/t/inline-script-for-round-off-float-field-is-not-working/273454 "2021-05-19T22:43:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sandeep\_Raju](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@Sandeep\_Raju](https://discuss.elastic.co/u/Sandeep_Raju)\
**Post date:** [May 19, 2021, 10:43pm UTC](https://discuss.elastic.co/t/inline-script-for-round-off-float-field-is-not-working/273454/1 "2021-05-19T22:43:13Z")

</div>

Hi all,

I'm trying to display average of a field in visualization bucket.

But when i use below code in inline text of advanced JSON for an integer value, I dont get.  
I dont want decimal values.

```auto
{
  "script": {
"inline":"Math.round(doc['DC_AMOUNT'].value * 100.0)/100.0",
    "lang": "painless"
  }
}

```

It works for buckets when i round off values.  
But when i take an average of fields and try to implement, it does'nt work.  
Any help

---

<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:** [May 20, 2021, 11:08am UTC](https://discuss.elastic.co/t/inline-script-for-round-off-float-field-is-not-working/273454/2 "2021-05-20T11:08:17Z")

</div>

Inline scripts don't work for aggregations like average. If you just want to round a field, you can do that by configuring the field formatter for this field in the index pattern: [Numeric field formatters | Kibana Guide [7.12] | Elastic](https://www.elastic.co/guide/en/kibana/current/field-formatters-numeric.html)

---

<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:** [June 17, 2021, 11:08am UTC](https://discuss.elastic.co/t/inline-script-for-round-off-float-field-is-not-working/273454/3 "2021-06-17T11:08:19Z")

</div>

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