# Totals not adding up correctly for % fields

**URL:** <https://community.amazonquick.com/t/totals-not-adding-up-correctly-for-fields/24103>\
**Category:** Q&A\
**Tags:** analysis, calculations, charts, Business-Intelligence-Engineer, quick-sight\
**Created:** [January 24, 2024, 2:36am UTC](https://community.amazonquick.com/t/totals-not-adding-up-correctly-for-fields/24103 "2024-01-24T02:36:24Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ntjc](https://avatars.discourse-cdn.com/v4/letter/n/7bcc69/32.png) [@ntjc](https://community.amazonquick.com/u/ntjc)\
**Post date:** [January 24, 2024, 2:36am UTC](https://community.amazonquick.com/t/totals-not-adding-up-correctly-for-fields/24103/1 "2024-01-24T02:36:24Z")

</div>

I’m getting incorrect totals for my % field. instead of getting the overall % profit, it’s adding the % values. the % value is calculated value for earnings based on the initial investment. Anyone familiar with how to fix?  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/8/1/81bb804116128c08d5ac482ecacc3984fd22ff75.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:** [January 24, 2024, 6:29am UTC](https://community.amazonquick.com/t/totals-not-adding-up-correctly-for-fields/24103/2 "2024-01-24T06:29:45Z")

</div>

Hi @ntjc

how would be great you can share the calculation as well as the profit numbers.  
Only with the screenshot i would say it looks right.

BR

---

<div class="post-metadata">

**Author:** ![ntjc](https://avatars.discourse-cdn.com/v4/letter/n/7bcc69/32.png) [@ntjc](https://community.amazonquick.com/u/ntjc)\
**Post date:** [February 5, 2024, 4:35am UTC](https://community.amazonquick.com/t/totals-not-adding-up-correctly-for-fields/24103/3 "2024-02-05T04:35:41Z")

</div>

Hi Erik, this is an example scenario. The returns are adding up to 40% but it should be 20% on the dashboard  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/4/3/439659a841a5befcde3dd3368f339e545a6015b1.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:** [February 5, 2024, 5:45am UTC](https://community.amazonquick.com/t/totals-not-adding-up-correctly-for-fields/24103/4 "2024-02-05T05:45:33Z")

</div>

Hi @ntjc  
In that case you need an avg aggregation and not sum.  
BR

---

<div class="post-metadata">

**Author:** ![ntjc](https://avatars.discourse-cdn.com/v4/letter/n/7bcc69/32.png) [@ntjc](https://community.amazonquick.com/u/ntjc)\
**Post date:** [February 5, 2024, 6:17am UTC](https://community.amazonquick.com/t/totals-not-adding-up-correctly-for-fields/24103/5 "2024-02-05T06:17:45Z")

</div>

I see, but I want the other fields to sum up, while that % field to average. is that possible?

---

<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:** [February 5, 2024, 12:15pm UTC](https://community.amazonquick.com/t/totals-not-adding-up-correctly-for-fields/24103/6 "2024-02-05T12:15:07Z")

</div>

isnt your table something like  
 ![grafik](https://d1wl4jav5dp96l.cloudfront.net/original/3X/a/b/ab3152a9f362f571d226819bba8a1f40f972415e.png)  
Attention to the value area!

---

<div class="post-metadata">

**Author:** ![ntjc](https://avatars.discourse-cdn.com/v4/letter/n/7bcc69/32.png) [@ntjc](https://community.amazonquick.com/u/ntjc)\
**Post date:** [February 6, 2024, 9:19am UTC](https://community.amazonquick.com/t/totals-not-adding-up-correctly-for-fields/24103/7 "2024-02-06T09:19:36Z")

</div>

Hey Erik, I really appreciate you taking your time to reply to this thread. I was just able to get a grasp of the issue w/ the calculation and resolved it. Thanks!

---

<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:** [February 6, 2024, 12:10pm UTC](https://community.amazonquick.com/t/totals-not-adding-up-correctly-for-fields/24103/8 "2024-02-06T12:10:56Z")

</div>

HI @ntjc  
perfect. Could you please solve the topic?  
BR