Sum of Negatives number wrong result

Help
1

Hi,
i’m doing this sample operation:
sum1=-0,53
sum2=0,48
sum3=0,05
Then return sum1+sum2+sum3 and the result should be 0. But the result is -4.16333634234434E-17.

sum
sum1565×789 46.2 KB
sum2
sum21113×718 17.5 KB

2

what type are sum1,sum2,sum3 and sum this might be a problem with doubles or floats
you could try change them all to decimals but not sure if it will help

3

They are doubles

4

did you try changing them to the type “decimal” and did this help?

5

Done thanks now it works i’ll test it more

6

Hi @Mustafa_Hamed

Check this

DataTableName.AsEnumerable.Sum(Function(x) If(IsNumeric(x(“Amount”).ToString.Trim),CDbl(x(“Amount”).ToString.Trim),0))

Th@nks
@shwin.S