I don't understand why this isn't working. I literally used this same formula earlier in this flow. But everytime I type in ENDIF it makes the end go grey and throws out an error. Please help.
Hi @jmorris24
Get rid of the quotes surrounding your numbers in either your original formula or the new one that @jdunkerley79 provided. The error is being caused by using a logic formula to match a number asked as a text.
If this solves your issue please mark the answer as correct, if not let me know!
Thanks!
Phil
I've seen the formula tool do this before when the expression reaches a certain complexity.
I'd suggest simplifying the expression:
IF [Difference Start to Transaction] = '0' THEN "A - Original Purchase" ElseIf [Difference Start to Transaction] IN ('1','2','3') THEN "B - 1st Q" ElseIf [Difference Start to Transaction] IN ('4','5','6') THEN "C - 2nd Q" ElseIf [Difference Start to Transaction] IN ('7','8','9') THEN "D -3rd Q" ElseIf [Difference Start to Transaction] IN ('10','11','12') THEN "E -4th Q" Else "None" ENDIF
as that might help the UI.
If you can post the workflow with the issue happy to look
I tried that but I am getting the same error. I can't share the flow because it is a bunch of transaction data. But here is a screen shot of it.
Any other ideas?
That was it. Thanks!
So if you don't use any quotes for a number and you use " double quotes for text. Do you ever use ' single quotes in alteryx?
