I'm trying to convert an Excel function using the Formula Tool in Alteryx and I'm running into an issue.
Value A = 1st Value
Value B = 2nd Value
Value C = Column where we are performing operation
Essentially:
IF Value A (Sheet1) = Value B (Sheet2), then Return Value B (Sheet2) OR
IF Value B does note equal Value A, then 0.
I keep getting a Malformed IF Statement message from Alteryx, due to to the 0. Here's the formula I have:
IF [Value A] = [Value B] THEN
[Value B] ELSEIF
[Value A] != [Value B] THEN 0
ENDIF
Thanks in advance for the help.
Ish
Solved! Go to Solution.
IF [Value A] = [Value B] THEN
[Value B] ELSE
0
ENDIF
Thank you!!! (Fist Bump)