# Error - % in totalizer visao

**URL:** <https://community.amazonquick.com/t/error-in-totalizer-visao/22690>\
**Category:** Q&A\
**Tags:** error, calculations, Business-Intelligence-Engineer, quick-sight\
**Created:** [December 14, 2023, 12:40am UTC](https://community.amazonquick.com/t/error-in-totalizer-visao/22690 "2023-12-14T00:40:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![GuiFox](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/guifox/32/6486_2.png) [@GuiFox](https://community.amazonquick.com/u/GuiFox)\
**Post date:** [December 14, 2023, 12:40am UTC](https://community.amazonquick.com/t/error-in-totalizer-visao/22690/1 "2023-12-14T00:40:51Z")

</div>

Goodnight!  
I’m having difficulty getting the subtotal to calculate the % correctly

Has anyone ever experienced this?

![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/a/6/a6a4c9e809bbfd1f4b329fcf131e0d2e39f81a97.png)

---

<div class="post-metadata">

**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\
**Post date:** [December 14, 2023, 6:51am UTC](https://community.amazonquick.com/t/error-in-totalizer-visao/22690/2 "2023-12-14T06:51:22Z")

</div>

Hi @GuiFox  
It’s a common issue as you can’t sum the percentage.  
Did you tried to set the aggression to avg?  
BR

---

<div class="post-metadata">

**Author:** ![GuiFox](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/guifox/32/6486_2.png) [@GuiFox](https://community.amazonquick.com/u/GuiFox)\
**Post date:** [December 14, 2023, 7:59pm UTC](https://community.amazonquick.com/t/error-in-totalizer-visao/22690/3 "2023-12-14T19:59:07Z")

</div>

unfortunately avg doesn’t work. It comes very close but it doesn’t work

---

<div class="post-metadata">

**Author:** ![WLS-DM](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-dm/32/36109_2.png) [@WLS-DM](https://community.amazonquick.com/u/WLS-DM)\
**Post date:** [January 4, 2024, 4:13pm UTC](https://community.amazonquick.com/t/error-in-totalizer-visao/22690/4 "2024-01-04T16:13:41Z")

</div>

Hello @GuiFox, were you able to find a workaround for this? If so, would you post the steps you took to accomplish that? Otherwise, let me know if you have any further follow-up questions and we can try to get your solution closer to your desired output. Thank you!

---

<div class="post-metadata">

**Author:** ![WLS-DM](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-dm/32/36109_2.png) [@WLS-DM](https://community.amazonquick.com/u/WLS-DM)\
**Post date:** [January 8, 2024, 5:25pm UTC](https://community.amazonquick.com/t/error-in-totalizer-visao/22690/5 "2024-01-08T17:25:44Z")

</div>

Hello @GuiFox, since we have not heard back from you, I will go ahead and archive this topic. If you have any further questions on this, please post a new topic in the community and link to this question. That will ensure you are at the top of the priority list to receive a response from one of our Quick Sight experts. Thank you!

---

<div class="post-metadata">

**Author:** ![WLS-DM](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-dm/32/36109_2.png) [@WLS-DM](https://community.amazonquick.com/u/WLS-DM)\
**Post date:** [January 8, 2024, 5:25pm UTC](https://community.amazonquick.com/t/error-in-totalizer-visao/22690/6 "2024-01-08T17:25:52Z")

</div>

Archived on January 8, 2024, 5:25pm UTC