Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try this
Num(Round(A-B), '#')
Very quick and brilliant answer. It is working fine. Thanks a ton...
And yet you did not mark my response as correct ...
Anyways, I am glad it worked...
I have marked as correct...Thanks