# How to avoid rounding for currency values?

**URL:** <https://discuss.elastic.co/t/how-to-avoid-rounding-for-currency-values/117535>\
**Category:** Kibana\
**Created:** [January 29, 2018, 9:20pm UTC](https://discuss.elastic.co/t/how-to-avoid-rounding-for-currency-values/117535 "2018-01-29T21:20:27Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![xeraa](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/xeraa/32/48181_2.png) [@xeraa](https://discuss.elastic.co/u/xeraa)\
**Post date:** [November 22, 2018, 3:57pm UTC](https://discuss.elastic.co/t/how-to-avoid-rounding-for-currency-values/117535/4 "2018-11-22T15:57:17Z")

</div>

Building on the answer from [Wrong returned Values on simple SUM-Aggregation](https://discuss.elastic.co/t/wrong-returned-values-on-simple-sum-aggregation/156690/3), I have the following 3 documents in my dataset:

```auto
PUT sap-lo-po/_doc/1
{
  "EBELN": "4500017596",
  "EKPO": [
    {
      "NETWR": 149314.2
    }
  ]
}
PUT sap-lo-po/_doc/2
{
  "EBELN": "4500017596",
  "EKPO": [
    {
      "NETWR": 314.1
    }
  ]
}
PUT sap-lo-po/_doc/3
{
  "EBELN": "4500017596",
  "EKPO": [
    {
      "NETWR": 200
    }
  ]
}

```

I think the visualization based on this data is then correct:

 ![Kibana%202018-11-22%2016-56-22](https://us1.discourse-cdn.com/elastic/original/3X/9/6/9618d63b7d2b780083725407311fc29a8d34c632.png)

---

_[View the full topic](https://discuss.elastic.co/t/how-to-avoid-rounding-for-currency-values/117535)._