# Sum value remove decimal part

**URL:** <https://community.amazonquick.com/t/sum-value-remove-decimal-part/5677>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [August 30, 2022, 9:14am UTC](https://community.amazonquick.com/t/sum-value-remove-decimal-part/5677 "2022-08-30T09:14:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![zhuoliuzhou](https://avatars.discourse-cdn.com/v4/letter/z/a87d85/32.png) [@zhuoliuzhou](https://community.amazonquick.com/u/zhuoliuzhou)\
**Post date:** [August 30, 2022, 9:14am UTC](https://community.amazonquick.com/t/sum-value-remove-decimal-part/5677/1 "2022-08-30T09:14:28Z")

</div>

This bug happens to one of my datasets, due to confidentiality issue I can’t share pic here.

The problem is I have a column named “qty” which stands for quantity, and it is “Decimal” type in quicksight. In a table visualization (or pivot table or any others), when I use max, min, avg to aggregate, the result can show decimal part, however, if I use sum, then the decimal disappear.

E.g., one record has qty of 1.8, max, min and avg all produce 1.8, but sum gives 1. I use 4 digit place to show the data, can sum gives 1.0000.

Pls help!

---

<div class="post-metadata">

**Author:** ![Naveed](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/naveed/32/961_2.png) [@Naveed](https://community.amazonquick.com/u/Naveed)\
**Post date:** [August 30, 2022, 10:28am UTC](https://community.amazonquick.com/t/sum-value-remove-decimal-part/5677/2 "2022-08-30T10:28:48Z")

</div>

Hi,

just change the formate of the calculated field.  
just like given below its percentage you can use it to change in number and chose your formate what you want 🙂

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