Population without null records

[Asiolinka]

Hi,

How can I use WHERE with NULL to obtain population without null records for chosen field?

Tried where LEN(FIELDNAME)>0 but it is  not working with real results.

Thank you in advance.

[Kushal_Chawda]

@Asiolinka  LEN(trim(FIELDNAME))>0

[Rams-]

Hi, 

You can use where (Fieldname) < > 0  in backend

If you need further help,  can you share your dataset? 

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[Asiolinka]

It does not work. 

I found 100 nulls (by using IsNull) in one field. 

Now I need to find another errors but using population without 100 nulls I found. 

Tried LEN/trimLEN -> population still include number of nulls 

where (Fieldname) <> 0 population is bigger than this with nulls.

I should have smaller population after excluding Nulls..  

[Rams-]

Can you share your data table

[Asiolinka]

I am so sorry but I can not show it here. 

[Kushal_Chawda · Accepted solution]

@Asiolinka  try this then

where LEN(trim(FIELDNAME))>0 or not isnull(FIELDNAME)