Display a string when two fields are null

[kakani87]

Hi Folks ...

Here I want to show In a chart the status based on two fields all the status able to show with the below expression but when two fields they are Null I would like to show as 'Abscent'

here in my case this is showing as third scenario as 'OnSite'

Can any one correct the syntax when both the fields they are null show as 'Abscent'

if(column(1)<column(2),'ProperEntry',

if(column(1)>column(2),'RemoteEntry',

if(IsNull(column(1)),'OnSite',

if(IsNull(column(2)),'Missing',

if(IsNull(column(1) and column(2)) ,'Abscent'

//if(IsNull(column(1)) and IsNull(column(2)) ,'Abscent'

)

)

)

)

)

Regards,

Kishore.

[tamilarasu · Accepted solution]

Hi SaiKishore,

if(column(1)<column(2),'ProperEntry',

if(column(1)>column(2),'RemoteEntry',

if(IsNull(column(1)) and IsNull(column(2)) ,'Abscent',

if(IsNull(column(1)),'OnSite',

if(IsNull(column(2)),'Missing'

)

)

)

)

)

[kakani87]

Thanks a lot this worked.

But the same i entered in the post with line commented

Where I went wrong

//if(IsNull(column(1)) and IsNull(column(2)) ,'Abscent'

[kakani87]

Can we provide a filter for all the Status displayed

Inorder to filter Each status

     Status:

1. ProperEntry
2. RemoteEntry
3. OnSite
4. Missing
5. Abscent

[tamilarasu]

if(column(1)<column(2),'ProperEntry',

if(column(1)>column(2),'RemoteEntry',

if(IsNull(column(1)),'OnSite',

if(IsNull(column(2)),'Missing',

if(IsNull(column(1) and column(2)) ,'Abscent'

//if(IsNull(column(1)) and IsNull(column(2)) ,'Abscent'

)

)

)

)

)

The reason is the third condition is true in your if condition, so the next if conditions will not be considered. It is checking only the column(1) and it is null so it is returning "OnSite" and else part not considered.

[tamilarasu]

Listbox filter?

[kakani87]

Yes Tamil.