Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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:
count(distinct{$<KomDatenService={'*huawei*'}, St90={">31/12/2016"} >}Link_Rev)
or maybe
count(distinct{$<KomDatenService={'*huawei*'}, St90={"= St90 >= makedate(2017)"} >}Link_Rev)
thanks for the support. I have already defined null via variable as "Blank".
Try This
count(distinct{$<KomDatenService={'*huawei*'},
St90={'>31/12/2016','<>'''}
>}Link_Rev)
OR
count(distinct{$<KomDatenService={'*huawei*'},
St90={'>31/12/2016','<>$(=vBlank)'}
>}Link_Rev)