Mistake in If statement

[#1]

Hi All,

Below is the if query used in the expression

if(Off_Start_Date<>Null()

and len(trim(TermSheetSignedDateTime))=0,

if(Off_Status='Draft',Enq_ContactName,

if(Off_Status='Auto Approved',Enq_ContactName, 

if(Off_Status='Pending Approval',Enq_ContactName,

))))

Above expression gives 9 records. But when i select individual Off_Status it shows more.

Please help me with this.

Attached the Qvw.

Regards,

Keerthi KS

[sasiparupudi1]

Try the following to see why your if condition is having a problem

if(Off_Start_Date<>Null()

and len(trim(TermSheetSignedDateTime))=0,

if(Off_Status='Draft',Enq_ContactName,

if(Off_Status='Auto Approved',Enq_ContactName, 

if(Off_Status='Pending Approval',Enq_ContactName,Off_Status

))))

hth

Sasi

[#3]

when i select the Off_Status it shows the data. But in the expression its faining