# Regarding the total sum of calculated filed in the table

**URL:** <https://community.amazonquick.com/t/regarding-the-total-sum-of-calculated-filed-in-the-table/30878>\
**Category:** Q&A\
**Tags:** tables, analysis, calculations, dataset, Business-Intelligence-Engineer, quick-sight\
**Created:** [June 4, 2024, 9:05am UTC](https://community.amazonquick.com/t/regarding-the-total-sum-of-calculated-filed-in-the-table/30878 "2024-06-04T09:05:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![iamboram](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/iamboram/32/19718_2.png) [@iamboram](https://community.amazonquick.com/u/iamboram)\
**Post date:** [June 4, 2024, 9:05am UTC](https://community.amazonquick.com/t/regarding-the-total-sum-of-calculated-filed-in-the-table/30878/1 "2024-06-04T09:05:47Z")

</div>

Good day, All

I was confused as to why the total sum of the calculated field was wrong. Actually, it has to be 31,294 in total, not 31,267 in a box in red.

![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/3/5/3547c0f33e253f94a8033cbdaee8acdcf13a54e3.png)

I think because of the calculated formula, the wrong total sum happened.  
Here is the each of column’s formula. If there is anything I have to fix, please let me know. 🙂

**[Formula]**  
a: sum(net) / (sum(sale\_price)/1.1)  
b: sum(net) / (sum(dc\_sale\_price)/1.1)  
c: b - a  
d: c \* 0.7  
e: b - d  
f: e \* sum(dc\_sale\_price)/1.1

Best regards,  
Boram

---

<div class="post-metadata">

**Author:** ![prantika\_sinha](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/prantika_sinha/32/21878_2.png) [@prantika\_sinha](https://community.amazonquick.com/u/prantika_sinha)\
**Post date:** [June 5, 2024, 5:49am UTC](https://community.amazonquick.com/t/regarding-the-total-sum-of-calculated-filed-in-the-table/30878/2 "2024-06-05T05:49:33Z")

</div>

Hi @iamboram ,

How is the expected result computed ? Is it by summing up above rows?  
I believe since your calculation has different numerator and denominator aggregation, the total will be powered with the same formula  
e \* sum(dc\_sale\_price)/1.1 instead of sum of above rows.

Can you try calculating using the formula on totals of the dependent field and see if that is a match ?

Since I have less context on your use case, it will be difficult to validate the formula used.

Thanks,  
Prantika

---

<div class="post-metadata">

**Author:** ![iamboram](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/iamboram/32/19718_2.png) [@iamboram](https://community.amazonquick.com/u/iamboram)\
**Post date:** [June 5, 2024, 8:05am UTC](https://community.amazonquick.com/t/regarding-the-total-sum-of-calculated-filed-in-the-table/30878/3 "2024-06-05T08:05:56Z")

</div>

Hi, @prantika\_shinha,  
Thank you for your answer.

I found out the issues on my own.  
Because of the decimal place, the result showed up like that.  
After I used ‘round-function’, I solved the issues.

Thank you!

Best regards,  
Boram