Substraction of same numbers show -0

[retko1985]

Hello,

I subtract 2 columns in straight table, and sometimes when the numbers are the same I get 0 and sometime I get -0

I also made sure that I dont have decimals in the columns I used for subtraction!

How is this possible?

Thank you.

[sunny_talwar · Accepted solution]

May be try this

Round(Num1) - Round(Num2)

or

Round(Num1 - Num2)

[Anil_Babu_Samineni]

This is weird behavior until unless you have long number? Do you have same values from 2 columns are more than that?

[retko1985]

It does work, Thank you.