# ROUND a MEAN value with a given amount of decimals?

**URL:** <https://community.influxdata.com/t/round-a-mean-value-with-a-given-amount-of-decimals/11699>\
**Category:** Telegraf\
**Tags:** influxdb, influxql, query\
**Created:** [October 23, 2019, 9:29am UTC](https://community.influxdata.com/t/round-a-mean-value-with-a-given-amount-of-decimals/11699 "2019-10-23T09:29:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jcrombez](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/jcrombez/32/3795_2.png) [@jcrombez](https://community.influxdata.com/u/jcrombez)\
**Post date:** [October 23, 2019, 9:29am UTC](https://community.influxdata.com/t/round-a-mean-value-with-a-given-amount-of-decimals/11699/1 "2019-10-23T09:29:54Z")

</div>

I can’t find in the documentation how i’m supposed to do something like this :

```auto
SELECT ROUND(MEAN(value), 2) ...

```

to get a value like `1.79` instead of `1.7925925925925925.`

---

<div class="post-metadata">

**Author:** ![Pooh](https://avatars.discourse-cdn.com/v4/letter/p/f05b48/32.png) [@Pooh](https://community.influxdata.com/u/Pooh)\
**Post date:** [October 23, 2019, 9:46am UTC](https://community.influxdata.com/t/round-a-mean-value-with-a-given-amount-of-decimals/11699/2 "2019-10-23T09:46:47Z")

</div>

Try round(mean(value)\*100)/100 …

See also [Implement floor, ceil, and round functions by Ahmah2009 · Pull Request #9632 · influxdata/influxdb · GitHub](https://github.com/influxdata/influxdb/pull/9632)

Regards,

Antony.

---

<div class="post-metadata">

**Author:** ![jcrombez](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/jcrombez/32/3795_2.png) [@jcrombez](https://community.influxdata.com/u/jcrombez)\
**Post date:** [October 23, 2019, 10:01am UTC](https://community.influxdata.com/t/round-a-mean-value-with-a-given-amount-of-decimals/11699/3 "2019-10-23T10:01:57Z")

</div>

Thanks for the tips Antony !

Too bad the ROUND function isn’t like the SQL one, it would be a lot more readable 🙂