Result of Caluclated Column is always integer instead of decimal (Power Query)

[Anra]

I need to make some calcluation in PowerQuery, but the added column always returns only an integer value, even the used columns in the calculation are of type decimal. 

What I need is the difference between the first two clumns and what should be 0.770532 for the first row, not 1 what seems to be the rounded value.

[PhilipTreacy]

Hi @Anra 

Without seeing your code I can't say what's happening because subtracting one column from the other should give the correct result.  It does for me when I try it.

Are you sure there isn't a step that changes the result column to Whole Number before it is changed to Decimal Number?

Regards

Phil