How can I use an IF THEN ELSE statement in the Expression Builder when importing a job? I keep getting a syntax error.
For my current example: I'm looking to import item shipping weights. I already have my import value assigned to Temp001. So now I want to apply a calculation for ShipWeight...If Temp001 is empty, return/assign the current shipping weight that's already in our system, else return/assign the new import value (Temp001).
IF Temp001$="" THEN ${CI_Item.ShipWeight$} ELSE Temp001$
This feels correct, but it returns a "Expression syntax error. Error #26: Variable type invalid." What am I doing wrong? Is there another way I can create an IF THEN ELSE calculation?