Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Decimal part removed when SUM

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.

Reports

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    7 years ago
    Hi there

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

    My Measure = SUM(Table[Column Name])