Null Value Filter

[Anonymous]

Dear Experts,

I have a table with one field say Hazard Types which doesn't have any null field.

When I connect this with my data model with many other tables there may few unmatched values (which may not Hazardours goods)

When I try to plot the straight table with many other values few Hazard Types values are null which is actually correct.

I have a list box of "Hazard Types" in my layout,now user wants to add one extra value "null" in this list box which should filter all the associated null values in the straight table.

Is this possible?

Thanks & Regards

Jeba

[tobias_klett]

Hi Jebamalai,

why don't you do another resident load and fill the null values like this:

if(isnull( [Hazard Types]) , 'null', [Hazard Types] ) as [Hazard Types],

Hope this helps
Tobias

[Anonymous]

I have so many tables to do such resident