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

[tamilarasu]

Attachment missing..!!!!

[andrespa]

Don't see thw qvw...

[jagan]

May be because of this conditions data is filtering

Off_Start_Date<>Null()

and len(trim(TermSheetSignedDateTime))=0,

did you applied in your selections?

There is no attachment in your post.

Regards,

Jagan.

[Anonymous]

TRY BRACKETS AROUND FIRST EXPRESSION

if((Off_Start_Date<>Null())

and (len(trim(TermSheetSignedDateTime))=0),

[Anonymous]

Try this one:

if(Off_Start_Date<>Null() and len(trim(TermSheetSignedDateTime))=0,

if(Off_Status='Draft' or Off_Status='Auto Approved' or Off_Status='Pending Approval',Enq_ContactName

))

[#7]

Yes i have applied. Attached the Qvw

[#8]

Still its the same

[#9]

tried but not working

[Anonymous]

if you define an else you get more data

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, 'else'

))))

so obviously there are more datasets wgich doesnot meet any of the above conditions