I am finding a difference of two double value which are same but instead of zero it returns Scientific notation.
i.e.
1,484.14 - 1,484.14 = 2.27373675443232E-13
Why?.
Alok.
I am finding a difference of two double value which are same but instead of zero it returns Scientific notation.
i.e.
1,484.14 - 1,484.14 = 2.27373675443232E-13
Why?.
Alok.
Because floating point is just an approximation. Try using Currency data type and see what happens.