# Incorrect AVERAGE value

**URL:** <https://community.amazonquick.com/t/incorrect-average-value/4573>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [July 6, 2022, 2:44pm UTC](https://community.amazonquick.com/t/incorrect-average-value/4573 "2022-07-06T14:44:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eleri](https://avatars.discourse-cdn.com/v4/letter/e/b5e925/32.png) [@Eleri](https://community.amazonquick.com/u/Eleri)\
**Post date:** [July 6, 2022, 2:44pm UTC](https://community.amazonquick.com/t/incorrect-average-value/4573/1 "2022-07-06T14:44:26Z")

</div>

I’m trying to calculate AVERAGE and expecting to see 8 ( (11+5) /2 ), but I’m seeing 8.33  
How? What do I need to do to get 8?

![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/0/07a31cc6b8d40c4f496e99b5b1f69541514cd09f.png)

---

<div class="post-metadata">

**Author:** ![Kellie\_Burton](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/kellie_burton/32/2603_2.png) [@Kellie\_Burton](https://community.amazonquick.com/u/Kellie_Burton)\
**Post date:** [July 8, 2022, 8:24pm UTC](https://community.amazonquick.com/t/incorrect-average-value/4573/2 "2022-07-08T20:24:08Z")

</div>

Hi Eleri! It appears you are taking AVG for total usage days and then taking an Avg of that AVG for a total which may be causing the issue. You may take a look at using the AvgOver function - [avgOver - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/avgOver-function.html)