Nested if else when first if is true

[aashishbhardwaj]

I am new to Alteryx and trying to use nested if-else statement. I tried searching but didn't get a case similar to mine. let us say passing marks for in two main subjects are 30 each and to pass overall student should be present in the class 90% of the time. What I need is

if (Marks1 > 30 and Marks2> 30 Then ( If (Attendance > 90), then "PASS" else "FAIL due to less attendance"), else "FAIL due to fewer marks") so I want that if first statements are true then I can have another if statement.

[df]

Hi @aashishbhardwaj,

just like you said yourself 🙂

You can also work with filters and union:

Does this help?

Cheers
David

[grazitti_sapna · Accepted solution]

Hi @aashishbhardwaj , I mocked up a workflow I hope it helps.

Thanks.