Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Below is the if statement
If((CurrentStatus<>'Expired' or CurrentStatus<>'Dropped'),
if(Enq_Followup_Date<>Null() and len(trim(SitevisitDate))=0 and len(trim(Off_Start_Date))=0
and len(trim(TermSheetSignedDateTime))=0
,Enq_ContactName)
)
But when Currentstatus is selected its showing data for Expired and Dropped also.
Please help me with this. is there any mistake in if statement.
Regards,
Keerthi KS
If(CurrentStatus<>'Expired' or CurrentStatus<>'Dropped') and
Enq_Followup_Date<>Null() and len(trim(SitevisitDate))=0 and len(trim(Off_Start_Date))=0
and len(trim(TermSheetSignedDateTime))=0
,Enq_ContactName)
Check number of closing brackets..
It will show the null values as expression output.