expression

[everest226]

i have a table where i need to add a single  column which will display if student  pass or fail

the field from data model is

NOTE- in single column

1. Pass Ind: A Y/N 1/0 dual flag that indicates whether the Student pass 
2. Fail Ind: A Y/N, 1/0 dual flag that indicates whether the student Fail

Any suggestion would be helpful

tamilarasu‌

stalwar1‌

-        

[Oleg_Troyansky]

You need to explain your problem in a bit more detail, and possibly post a sample app. It's not too clear what is your issue.

[rahulpawarb · Accepted solution]

Hello Everest,

I agree with Oleg; please elaborate your request.

However, I am just passing a guess answer. Use below expression to get the desired results.

if(A='Y' OR A=1, 'Pass','Fail') AS Status

Hope this will help.

Thank you!

Rahul

[vinieme12]

Try below

Dual (If (A='Y','Pass','Fail'),If (A='Y',1,0)) as Status

[tamilarasu]

Hi Ujjwal,

Sorry for the delayed response. Could you explain your question a bit more or post some sample data and expected output? It would be easy for us to help you quickly.

[everest226]

Thanks

if(A='Y' OR A=1, 'Pass','Fail') AS Status

works perfectly

[rahulpawarb]

Cheers...

Rahul