Hi
I am trying to use an IF Then formula to change the data, however when the condition is met, rather than return the text string, it returns a "0".
Here is the formula I have written:
IF [SKU NUMBER]='126091' THEN [VINTAGE]='Y2020' ELSE [VINTAGE]ENDIF
The formula is looking at this data set:
And when it finds the SKU NUMBER 126091 instead of changing the vintage to 'Y2020' it returns a '0'
The data type for SKU NUMBER and VINTAGE are VW_String
Thank you to anyone who can help me with this.
Solved! Go to Solution.
a formula acts on either an existing variable or a new variable. So....
IF [SKU NUMBER] = "126091" THEN "Y2020"
ELSE [VINTAGE]
ENDIF
Cheers,
Mark
@MarqueeCrew Thank you SO MUCH!!
One more question....
I have about 50 different SKU NUMBERS that I would like to follow the same rule.
IF [SKU NUMBER] = XYZ THEN 'Y2020' ELSE [VINTAGE] ENDIF
Rather than create 50 individual if/then statements what would be a recommended formula to use?
Thank you for any help you can provide.
IF [SKU NUMBER] IN ("12345","12353","12361")
THEN "Y2020"
ELSE [VINTAGE]
ENDIF
cheers,
mark
p.s. It's okay to mark this as a solution too.