Hi Alteryx Team,
I have a problem in framing a formula for the below input file
Age | S/N |
0 | S |
0 | S |
6 | S |
5 | N |
I want to frame a formula in such a way that I get another column 'results' with yes/no as output. If the Age is 3 and above and S/N is 'S' Then the result should be Yes and if the age is 5 and above and S/N is 'N' then the result should be Yes. Rest all that don't meet the above 4 criteria's should be a No.
Output Required -
Age | S/N | Result |
0 | S | No |
0 | S | No |
6 | S | Yes |
5 | N | Yes |
Please help.
This is my formula but it gives an output as 0,-1,etc idk why?
IF [NFA Age]>3
THEN "Yes"
Else "No"
AND IF [NFA Age]>=5 AND [Swap Dealer/Non Swap Dealer]="Non Swap Dealer"
Then "Yes"
Else "No"
Endif
Endif
Solved! Go to Solution.
Hi @henrygeorge,
Is this the result you're looking for?
If so then you will want to be using the following formula:
IF [Age] >= 3 AND [S/N] = 'S'
THEN 'Yes'
ELSEIF [Age] >= 5 AND [S/N] = 'N'
THEN 'Yes'
ELSE 'No'
ENDIF
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workbook for you to download if needed.
Regards,
Jonathan