If condition not working

[ramyasaiqv]

Hello All,

I’m trying to derive “Open_Date” from “Date “  in the script using the following condition but getting nulls.  Please help me.  Attached sample qvw, excel and expected result set for reference. Thank you,

if(Type= 'BCT' and Status='Accepted'  and Type='ECT' and Status='Open' or '-', Date) as Open_Date

Expected Result:  3/12/2016 (BUS)

8/20/2015 (PTZ)

Ramya

[sunny_talwar · Accepted solution]

How can type be BCT and ECT at the same time... same problem with Status... may be you need or condition?

[krishnacbe]

Check the attached file. hope it helps.

Changed the formula as below.

if((Type= 'BCT' or Type='ECT') and (Status='Accepted' or Status='Open'), Date) as Open_Date

[ramyasaiqv]

Thank you Sunny.

Ramya

[ramyasaiqv]

Thank you for the response Krishnapriya.

Ramya