Count with AND OR Function

[#1]

Dear All,

I want to have all which is in this year plus i dont want blanks as well. but the function is not giving me the result.

count(distinct{$<KomDatenService={'*huawei*'},

St90={'>31/12/2016','<>blank'}

>}Link_Rev)

[swuehl]

I assume your St90 field shows date values. 'blank' mean NULL?

Then doing a numeric search should automatically exclude the records where St90 shows NULL.

You just need to create a numeric search string that correctly selects the date values:

Dates in Set Analysis

Get the Dates Right

Why don’t my dates work?

count(distinct{$<KomDatenService={'*huawei*'}, St90={">31/12/2016"} >}Link_Rev)

or maybe

count(distinct{$<KomDatenService={'*huawei*'}, St90={"= St90 >= makedate(2017)"} >}Link_Rev)

[#3]

thanks for the support. I have already defined null via variable as "Blank".

[aarkay29]

Try This

count(distinct{$<KomDatenService={'*huawei*'},

  St90={'>31/12/2016','<>'''} 

  >}Link_Rev)

OR

count(distinct{$<KomDatenService={'*huawei*'},

  St90={'>31/12/2016','<>$(=vBlank)'} 

  >}Link_Rev)