Formula Help

Question

Hi Alteryx Team,

I have a problem in framing a formula for the below input file

AgeS/N0S0S6S5N

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 -

AgeS/NResult0SNo0SNo6SYes5NYes

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

Jonathan-Sherman · Accepted Answer

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