Is it possible to have a calcuation so that when the result in a field changes from 0 to another number, it will do one thing, but if the number changes from another number that isn't zero, it does something else? Basically currently I have this:
If ( Quantity=0; "End" ; "Revise" )
Which I'm using for Ebay listing revision. So I upload this file to Ebays file exchange and it will end acutions that are 0 quantity, and change the quantity (revise) for any that arn't 0. But, I need a third option which is 'relist', for any that have gone from 0 to a number above 0. Does anyone know how I can possibly do this?