Decimal part removed when SUM

Anonymous — Wed, 30 Jan 2019 15:31:53 GMT

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.

Re: Decimal part removed when SUM

GilbertQ — Thu, 31 Jan 2019 04:34:45 GMT

Hi there

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

My Measure = SUM(Table[Column Name])