Remove -0 Value from data

[vipingarg23]

Hi Team,

I have two below tables and when I am doing A-B, it is giving the below result:

A	B	A-B
8.74	8.76	-0.02
8.76	9.74	-0.98

But When I am changing Number format for (A-B) as integer it is giving below result:

A	B	A-B
8.74	8.76	-0
8.76	9.74	-1

So here it is giving value as -0. I want to remove this negative sign from zero(0) as there is no mean of -0.

Can anybody help me?

[sunny_talwar · Accepted solution]

Try this

Num(Round(A-B), '#')

[vipingarg23]

Very quick and brilliant answer. It is working fine. Thanks a ton...

[sunny_talwar]

And yet you did not mark my response as correct ...

Anyways, I am glad it worked...

[vipingarg23]

I have marked as correct...Thanks