Issue facing in converting decimal to whole number

[pprakash]

Hi Guyz,

I am facing issue while converting data type decimal to whole number. when it converted it, it is not showing correct information for example there are 2 columns of decimal no and i added 1 new column in my report adding those 2 columns and change th datatype as whole no but it is giving incorrect information.

1st column (datatype decimal)   2 Column(datatype decimal)     New Col(1st col+2nd Clol)(datatype Whole number) 

                            40                                    40.5                                                                80

It should be 81 . i have also changed the datatype from edit query also but problem still the same. please help

[v-yulgu-msft · Accepted solution]

Hi @pprakash ,

The unexpected total value might be related to the source data of column2. You can see the difference from below screenshot. 

To deal with this behavior, you can add a calculated column with below DAX:

Column = ROUND(Table1[Column1],1)+ROUND(Table1[Column2],1)

Best regards,

Yuliana Gu

[Anonymous]

Hi @pprakash 

I did the same thing and got 81.

Could you share the file via dropbox or something so I can take a closer look?

I made them 2 decimal places to make sure it was 4.5 and not 4.499999 and rounded up as that might make the difference.