Calculated column result was truncated

[Anonymous]

Hi,

I'm working on calculated column, I spot the incorrect calculation.

Then I test the simple formula below. it seem to round the result to integer, althought the data type was decimal.

I have seen this couple time when I'm work in big table.

Thank you,

[FarhanAhmed · Accepted solution]

Change the Datatype to Decimal. It is showing "Whole Number"