So I have a file that is looking at product coming in through a shipment.
I have one field that shows the number of units shipped and another field that shows the number of units received.
In a third column I would like it to tell me if between those number it is positive or negative net via a formula.
Example
Units shipped Units received Quantity Delta 0 1 +1 1 0 -1
I know it's probably simple and I'm just not thinking of it but if someone could help me with a formula, I'd appreciate it.
Bookmarks