Decimal part removed when SUM

[Anonymous]

Hi,

We have a column with the format as decimal.

When we add this to table and set properties as sum, the decimal part is removed from the values. (not round off, direct whole number)

PFA a screenshot where the column has been added twice. When it is not summarised, we can see the decimal part, when summarised, we see zeroes

Please let us know if someone has a resolution, how to keep the actual decimal part.

[GilbertQ]

Hi there

Have you tried to create a measure and then format the measure?

My Measure = SUM(Table[Column Name])